Answered

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. 😕

I have the same question (0)

All responses (4)

Answers (1)

Sniderj1 21 on at

Like (0)

Report

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

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

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

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

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

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

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

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

Was this reply helpful? Yes No