Answered

Send email to multiple person(s) columns from SharePoint on click of a button in Powerapps

(0) Share

Report

Posted on by Aliyah1

I am creating an approval Power App. The app contains multiple levels of approvals, where each level can require multiple approvers.

When a request is cancelled by the creator on push of a button, I would like to send an email to notify all the approvers of the cancellation. The approvers are listed in a SharePoint list which includes four multiselect person columns.

How can I send one email, to all the approvers listed in the different person columns on push of a cancellation button?

(i.e. there is level 1 approver column with 2 people selected, level 2 approver column with 1 person selected, level 3 approver column with 2 people selected and so forth. I would like to send them all an email saying "The request has been cancelled by "User()")

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Aliyah1,

If you want to send out a group email to all approvers, you can use the following Outlook send email function:

Office365Outlook.SendEmailV2( //Adjust where necessary and add as many concats as you have fields Concat(RECORD_REFERENCE.ApproversField1, Email, "; ") & "; " & Concat(RECORD_REFERENCE.ApproversField2, Email, "; "), "Mail subject name", "Mail body goes here" )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
Aliyah1 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM ,

This solution worked perfectly! Thank you!