Sort on the Users list

DeepakK · 2023-04-17T20:41:52+00:00

There was an error rendering this rich post.

Hello all,

Hopefully this is a quick solution.

I'm looking for a way to sort the Users list based ontheir Read/Write properties.

Example: I have 25 users that have Write access to different cost centers. They should be ordered based on Center alphabetically.

Is this possible?

Accepted answers

BrunoRodriguez

Hello @DeepakK,

Create a module dimensioned by Users and use a saved view with a line item that contains the name of the users into a new list "Fake Users". Use the action to repopulate the list with new users as the model evolves.
Create a module dimensioned by the "Fake users" and make a find item of the native Users.
Create your Read / Write access in a module dimensioned by "Fake Users".
What you are going to sort is the "Fake Users" list, not the native list of users.

That is how theoretically you could make it happen, but I do not really know whether this is useful for the real application of this - which will come from step 4.

Cheers!

All comments

rob_marshall

@DeepakK

I don't believe that is possible as the Users list can't be sorted.

DeepakK

@rob_marshall

Oh no, that's tough news☹️.

We're having a hard time going through our user list and we want to add many more(100+).

Do you have recommendations on how to filter or search through the list? I know there is a Find function but any other ideas?

Appreciate your help.

BrunoRodriguez

Hello @DeepakK ,

@rob_marshall , would it work if they create a Fake User list and map the users with the Fake User list?

The new list should be text and sortable.

Cheers!

rob_marshall

@BrunoRodriguez

I was thinking of that and it might be a good idea, but the maintenance might be a bear if new lists require selective access.

But yes, a good thought and then have an action writing into the Users list.

DeepakK

Ok, let me try this out.

1) I should make a Fake Users list. This will have all the users and their emails imported in. Email = Code

2)Then I can have a module with their Read / Write access as line items. Then I can have a sort order setup for them.

3) I create an Action that writes back the Users and their Sort order to the main User list?

BrunoRodriguez

Hello @DeepakK,

Create a module dimensioned by Users and use a saved view with a line item that contains the name of the users into a new list "Fake Users". Use the action to repopulate the list with new users as the model evolves.
Create a module dimensioned by the "Fake users" and make a find item of the native Users.
Create your Read / Write access in a module dimensioned by "Fake Users".
What you are going to sort is the "Fake Users" list, not the native list of users.

That is how theoretically you could make it happen, but I do not really know whether this is useful for the real application of this - which will come from step 4.

Cheers!

pyrypeura

For maintenance I would also suggest having a cloudworks job to be scheduled once a day updating the Fake users list by adding new users and deleting the deleted users daily. This would make the maintenance easier as fake user list would be updated regularly. Also process could be published to dashboard in case of a mid day refresh is going to needed.

DeepakK

Hello @BrunoRodriguez @pyrypeura

This solution is working well enough. I created a module with teh Fake Users list that we can use in a dashboard and also have a Action to write back the permissions to the native Users list.

I can't do more than one choice. I have a Center Write that allows users to control more than one center. When I try to write that back, it won't allow it. My module line item is text formatted.
Do you know a way to prevent emails from being sent for new users? Or is that a requirement when they get access to a model?

Thanks so much!

pyrypeura

Hi,

When importin selective accesses Anaplan accepts only one access per column per row. To get order this you would need to have multiple rows so each user/cost center combination would be in it's own row.

Examples on import based security are built in these two models available in App Hub:

https://product.anaplan.com/automated-user-security-via-cost-center-ddc26846-632c-491e-93d1-7957da4e82bb

https://product.anaplan.com/automated-user-security-via-data-hub-22542739-afd8-4219-8740-8cc4bc913d58

pyrypeura

For the emails there is nothing we can do regarding those.

DeepakK

Thanks for the help everyone. I got a working solution for now. Hopefully, Anaplan finds an easy way for us to add multiple Selective Access.

Appreciate all the responses.

unknown

This content has been removed.

larrydibenedetto

@slope game said If the cost center information isn’t already in its own column, create a new column and manually or programmatically extract the cost center data for each user.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…