SharePoint list task to add user to group IF X item selected

[plangham]

I have a SharePoint list that is populated by users. 

I have a Power Automate task currently that is set to run once a day at 18.00 that creates an Azure AD account based on the completed fields in the SharePoint list. What I am trying to achieve is that depending on the answer given to a question which is a multiple choice answer, the task adds the user to a specific Azure AD group. Any help would be greatly appreciated and if any more details are required please let me know?

[royg · Accepted solution]

Hi @plangham,

There could be better ways to achieve your requirement but the easiest would probably be:

1. Get all the items from your list

2. For each item (apply to each) add a select action and add your multi choice column as the input.

for the map, switch to text mode and set it to ​item()?['Value']

3. After the select statement add a condition to check if the select result contains your specific key and act accordingly.

could resemble this:

Hope this helps

Roy

[plangham]

Hi, I have tried this and although it runs through successfully, the condition outcome is always NO. 

I have checked Outputs from the select statement and I can see my value there. Does it make a difference when the column field can have multiple choices selected i.e. choiceA, choiceb, choiceC 

In my screenshot the choice selected is "E-Mail"  my condition is set to contains "E-Mail"

[royg]

From step 2 in my list, you neglected the map switch to text mode. after that's done, set the expression as mentioned and you should be good to go

Roy

[plangham]

Hi

Switching to text mode generates an error?

[royg]

You need to type that into the expression dialog and not as free text. Please try that.

Roy

[plangham]

Sorry, I must be missing something here because when I switch to text mode I get this dialogue box?

I tried removing the current text and adding the statement and have tried using what is above in there already but still get the same error message?

[royg]

Remove everything from Map and click outside the action, then click inside the Map input again and you should be able to add dynamic contents:

[plangham]

Ah ok, I think I tried this but will try again. 

Does the "Value" part of  item()?['Value'] need to reflect anything?

[plangham]

Ignore that last statement... it worked. 

Thanks very much for your help. 

[royg]

Great, I'm glad it helped. The Value is the textual value of your choices (they are retrieved as an array, but we are only interested in the textual value which we want to compare to a static value - in your example "E-Mail").