Is it possible to pull Emails from a Gallery of dynamic list of Approvers, Concat the list and and use it as "To:" part of an Email?

(0) Share

Report

Posted on by SueA

555

Hi:

What is the best way to use a filtered list of Users/Approvers from a SPO list (also, showing this filtered list in a Gallery Items), Concat the emails of these Users/Approvers and use the string as "To:" string in formatting Email from a PowerApp?

(Note: my Gallery Items comes from query shown in Ref: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-Filter-a-list-with-having-other-SPO-list-with-Many-to/m-p/1945648#M488335)

Thank you,
SueA.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @SueA,

Do you mean how to concat emails from a gallery?

Concat(galleryName.AllItems, LabelName.Text, ", ")

Was this reply helpful? Yes No
Verified answer

SueA 555 on at

Like (1)

Report
Copy link

Link copied!

Yes. In the meantime I found this post and it did the trick.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Send-email-from-Gallery-distribution-list/m-p/661604
However, thank you for the tip none the less!
Regards,
SueA.

Was this reply helpful? Yes No