Multiselect Column Value Lookup

(0) Share

Report

Posted on by draymond11

Hi,

I have a SP List with AD_Group, a Choice column with multiple selections enabled. Looks like this:

Problem: in my flow (below), since enveloped by an 'Apply to Each', the 'Send email to BI' and 'Send Email to BI 2' actions are sending twice when more than one AD_Group is selected.

How do I get rid of the 'Apply to Each' but also refer to the contents of the AD_Group (multiselect enabled) column.

I tried to make a mirror image, calculated column copy of AD_Group, but you can't create calculated columns from multiselect Choice columns.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

Re: Multiselect Column Value Lookup

Hi @draymond11
Please try the below structure to your flow
Initialize a variable to be the condition for your email sending step , and determine whether it is true or false and then outside the Apply to each , add a condition to check if the HR Group = True then send email 1 otherwise send email 2

Hope this Helps you!

Was this reply helpful? Yes No