web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multiselect Column Val...
Power Automate
Answered

Multiselect Column Value Lookup

(0) ShareShare
ReportReport
Posted on by 20

Hi,

 

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

 

draymond11_0-1599590592264.png

 

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.

 

FlowB.JPG

 

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.

Categories:
I have the same question (0)
  • Verified answer
    Mira Ghaly Profile Picture
    11,415 Moderator on at

    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

    Mira_Ghaly_0-1599609786395.png

     

    Hope this Helps you!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard