Allow for multiple list items in user selective access when importing from a module into users


We use imports to update our user list with selective access, but cannot do this when one user can have multiple access, e.g. access to multiple countries in a list, because the line item in the module has to be dimensionned by the list itself and in the list we can only select one item. Alternatively we may run the action once with country A, then change to country B and ruen the import again, but that is time consuming, manual and the module cannot be used for auditing access anymore.

19 votes

New · Last Updated


  • Status changed to: New
  • Charly

    Hi @MagaliP,


    We're running into the same issue. Were you able to come up with a workaround?




  • Thanks Charly. The four workarounds I can think of and we have used depending on our models:

    1/ Manually add the second selective access (this works if you have a limited number of users facing this situation)

    2/ Run the import from the module into the users twice, once mapping with a column which contains the first access and then a column containing the second access (but depending on your number of users, the import can take several minutes, blocking your model in the meantime)

    3/ Not using selected access but DCA instead and then filters so they cannot see list items they should not have access to

    4/ Potentially you may try and change your list hierarchy to group country A and B under for example division 1, and give selective access to division 1 instead of the two countries separately (may cause big impact on hierarchy and space though)


    I hope that helps.

  • Hi,


    this works pretty easily, we do it all the time.

    The source module needs to have the user and the country dimension. Then make the selection a boolean, if true, write the code.

    Prepare your view with users and countries as rows and filter it on only what they have access to. Save it and use that as the source.

    It should be showing you one row for every country the user has access to. Access import is incremental, so every row will be imported successively and add to the access.

    The max I've imported with this numbers in the tens of thousands and no problem.

    If you want to reset the access, run a first import step with the role of "No Access" for that user.


    Repeat this for every dimension you need in selective access (if composite list you can manage several levels of the list in the same source module)

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!