Answered

Creating a Dynamic Email Distribution Function

(0) Share

Report

Posted on by APM1994

I have an App in which the users can create certain items. However, depending on the topic of that item, it needs to exclude certain people at different times.

I've created a popup with a 'tick box' section to tick the individuals who should be excluded.

I now want to build the list, and Automated Flow from this - However, I'm not sure how to tackle it in the best way...

As an example, let's say the standard email list associated with Product A goes to:

Person A, Person B, Person C, Person D

I want the user to be able to select Person D NOT to receive the email flow

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @APM1994 ,

Could you please share more details about your scenario? Which Control are you using to exclude users, a Gallery with Check boxes?

Generally speaking, it's not difficult for you to get all the users except for those excluded ones in a table/collection. For example, if it's a Gallery with Check boxes

Filter(Gallery.AllItems, Checkbox.Value = false).Email

So, you can pass the Emails to flow just use a Concat function to concatenate all the Emails and separated by semicolons:

Concat(Filter(Gallery.AllItems, Checkbox.Value = false),Email,";")

Best regards,

Was this reply helpful? Yes No
Verified answer

APM1994 43 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

Thanks for your input firstly.

I've maybe found a solution. Basically I have my standard list of emails which never changes, and then within the GUI, the user can select from a list of other emails which may/may not be included. I then join these lists together with ; separators to populate the "to" section of the email.

So it is a selection of who to INCLUDE in my solution, rather than who to EXCLUDE. But same outcome

Was this reply helpful? Yes No