Answered

Get multiple emails addresses from a lookup function

(0) Share

Report

Posted on by altyrocks

I'm trying to use the Office365Outlook.SendEmailV2 function and I don't want to hard can in the email addresses so I'm pulling the values for the addresses from a label on the form. The label uses a lookup function on a SharePoint list:

LookUp('Email Recipients', Title = "EmailValues", EmailAddress)

This works fine for 1 email address and I have to use 2 columns - 1 with the title "EmailValues" and another with the actual email address. What I would like is to have is just a SharePoint list of email addresses that can be read into the label (or directly inot the SendEmailV2 function similar to how the Choices function works for a dropdown.

As it stands, I have to put all the email addresses on one row in the SharePoint list and have a column called "EmailValues" which isn't all that user friendly.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @altyrocks,

Do you want to send email to all the email address in your SP list?

If so, I think you could use the concat() function to achieve this:

Office365Outlook.SendEmailV2(Concat(List.EmailAddress,EmailAddress,";"),"TEST","TEST")

Was this reply helpful? Yes No
altyrocks 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi,
Thank you for your response. I'm trying to understand the syntax.
I have a SharePoint list called Dining Vendor Email Recipients. It contains one column called EmailAddress. Currently, the list has one record with my email address.
So this is the syntax I used: Concat('Dining Vendor Email Recipients', EmailAddress, ";" )
This compiles correctly but when I run it, it tells me that the To: parameter can not be null. This leads me to believe I don't have something set up correctly.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @altyrocks,

Could you please check my formula one more time?

I have mentioned that you should refer to List.EmailAddress, so you should modify your formula as below:

Concat('Dining Vendor Email Recipients'.EmailAddress, EmailAddress, ";" )

Was this reply helpful? Yes No
altyrocks 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi,
You're a genius, that did the trick! Thank you for clarifying.

Was this reply helpful? Yes No