Answered

Send Email in OnSuccess of Form to Email Address in SharePoint List Column

(0) Share

Report

Posted on by cjwilson80

I have a PowerApp Form with a dropdown choice for 'Region.' There are about 11 possible outcomes for the Region. Depending on the selected region, I want to send an email to that specific region that is stored in a SharePoint list.

So far, I have a collection:

ClearCollect(
 colRegions,
 Filter(
 RegionEmails,
 Title = DataCardValue41.Selected.Value
 )
);

However, I'm not sure I'm doing this correctly. I have two columns in the SharePoint list. The first column, "Title" contains the Region Names that can be selected from the dropdown in the form. The second column is "RegionEmail" which contains the associated email address for the selected region.

How do I set this up in my app so that if someone chooses "Corporate New York", it finds that region in the Title column of my SharePoint list and then sends an email to the correct email address in the "RegionEmail" column?

Thanks in advance for all your help on this!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@cjwilson80

Are all the regions unique or do you have repeats in the list?

Also, you mention you have a dropdown with the regions in it...what is the Items property formula for that dropdown?

Was this reply helpful? Yes No
cjwilson80 95 on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes

Yes, all of the regions are unique and have different email addresses associated with each. The Items property of the drop down for that particular dropdown on the field is:
Choices([@'Corporate SKY Limit Form'].CreditOfficer)

Was this reply helpful? Yes No
Verified answer

cwebb365 3,294 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
You're on the right track. Just in your OnSuccess, for the to: field of the sendmail function would use

Lookup(RegionEmails, Title = DataCardValue41.Selected.Value).RegionEmail

in the to: part of the function. You don't need the collection, just utilize a lookup right inline of the sendemail function and you should be good.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@cjwilson80

So since you have the dropdown in place. I would suggest that you not do a double lookup as was suggested but instead use what you have already gathered in the app!

Assuming then that CreditOfficer is a lookup to your RegionEmails list...

Instead of having your Dropdown based on the Choices (which will only provide you a record with a value that you'll have to then re-lookup later), change the Items property to:

RegionEmails

Then you already have everything you need once!

So then your final email would be based on the dropdown selection...

Office365Outlook.SendEmailV2( DataCardValue41.Selected.Email, ...etc... )

Of course, you will want to do the email send in your OnSuccess action of your form, but that should give you what you want without the extra data operation.

Was this reply helpful? Yes No