Unanswered

Variable Help for Multi-Select SharePoint Power App Form Sending Multiple Emails

(0) Share

Report

Posted on by Sniderj1

I've been trying solutions I've read for a week and can't seem to get the steps just right so I'm posting my particular flavor of this apparently common issue.

I have a SharePoint Online Power App form with several multi-select fields. Each time more than one selection is made, it sends a distinct email for each selection. I want all selections in the array to be sent in one email as a string. I've gotten as far as getting my flow running, but no data is printed in the email. Below is the flow for one of the fields in question - LOB (Line of Business). I've tried adding a Compose action for testing, but it's always blank. 😕

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sniderj1 21 on at

Like (0)

Report

So, I've continued to play around and have gotten the below flow. It work, but sends 4 identical emails for a 2-selection multiselect field.

Was this reply helpful? Yes No
Verified answer

Ajinder31 530 on at

Like (1)

Report

Hi @Sniderj1 , I tried creating a similar flow on my side and it gets trigerred only once doesn't matter values how many selected in multi-choice column in Sharepoint List. Also, we can move Send out of Apply_to_each loop to stop sending emails for each item.

--------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
v-liwei-msft on at

Like (1)

Report

Hi @Sniderj1

The method @Ajinder31 provided is very good (I just provide a method to do it with a string variable)

Best Regards,

Levi

Was this reply helpful? Yes No
Sniderj1 21 on at

Like (0)

Report

Thank you @Ajinder31 & @v-liwei-msft ! Your solutions worked perfectly. Much appreciated!

Was this reply helpful? Yes No