How to retrieve multi row variable set data in form of record pills in flow designer.

[PriyanshuVerma1]

Hey everyone,

I recently made a catalog item to add /remove multiple users from assignment group. Below is the image of that flow

In this i am checking what role the groups has based on that i am sending out approvals and then based on approvals adding users to the assignment group.

The requirement now is to add multiple users to multiple groups. I believe i can use multi row variable set in catalog item.

We can use for each action and look up record to iterate through multi row variable set(array.object) and pull out information about user and group given as input.

I want to add ask for approval action and send approval, but using for each action if there are 5 users getting added to single group, then it will send approval to group manager 5 times.

I want to send one approval per group, no matter how many members are getting added to it like I was able to do in screenshot 1 when I was adding multiple users to single group. 

Is there a way I can get values from Multi row variable set values in flow designer and use them like data pills?

Or get unique group values in an array, that i can iterate through to send approvals to group managers.

By unique group value i mean : if we enter 5 user and out of these two users are getting added to same group, then in array we should have 4 group names in our new array.

Or there is any better approach i can follow to achieve the same goal.

[Mark Manders]

Where is the flaw? You are describing that your manager wants one email for all users that need to be added to the group and that logic is flawed, because approval is either 'yes' or 'no' and not 'yes for her', 'no for him'. 

If you are requiring approval for adding a user to a group, you should approve that for every single user. Too bad that someone asks it for 5 users at once. It will still get 5 approval records. The fact that you make it easier to request them by using MVRS is great, but the process should stay the same: approve the request of 1 user being added to your group.

You could go around this and inactivate the approval emails. Just create a new one that is triggered once a day to tell an approver that there are approval records waiting for him to approve. Then they will just get one email, once a day, if there are records.