Answered

Send email to all recipients listed in gallery

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. I am trying to send an email from powerapps to all recipients listed in a gallery. The code below works if I am choosing a single line, but not sure how to add in all members of the gallery.

Office365Outlook.SendEmailV2(Gallery25.Selected.UserEmailCapture,"Subject","Body")

I can make the gallery items a collection if that solves the issue as well.

Thanks in advance!

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @ckserra33,

If you want to mail all people listed within the Gallery control and the gallery data source contains an email field, you can use the Concat() function to achieve this:

Concat(GalleryName.AllItems, EmailFieldName, ";")

Change the galleryName and EmailFieldName to your specific case.

You can use this directly in the 'to' field (of the Office365Outlook.SendEmailV2 function) or set it as a variable and use that as the to field instead.
You also don't need to use the GalleryName.AllItems, you can reference your Data Source (or collection) directly.

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
ckserra33 421 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM Perfect! Thank you very much!!

Was this reply helpful? Yes No
bcmoyer16 2 on at

Like (0)

Report
Copy link

Link copied!

Is there a way that one could send an email to all users in a gallery that has been filtered by certain criteria? I'd like to send an email to all users with entries in a gallery from only the previous month, if that makes sense.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @bcmoyer16,

The code would be the same as was written above, because you already filter the Gallery.AllItems.

.AllItems only refers to the items shown within the gallery, not the items that are in the datasource connected to that gallery - if this makes sense.

You can also filter on the displayed gallery items should this be needed:

Concat( Filter( GalleryName.AllItems, Month(CreatedFieldName) = Month(Now()) - 1 ), EmailFieldName, ";" )

What I would suggest is creating a new, separate topic for your question with some context and Code snippets or screenshots.

I hope this helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello!
I am trying to use your idea for a workflow in power apps but it's not working. Maybe do you have any idea?

Genehmigungdeslaufwerke.Run(Concat(Gallery6_1.AllItems;Body);User().Email;PlainText(HtmlText1.HtmlText);HtmlTextApprove.HtmlText;HtmlTextNotApprove.HtmlText);;

my error is exactly in " (Concat(Gallery6_1.AllItems;Body) "

best regards 😄

Was this reply helpful? Yes No
dlwalla 4 on at

Like (0)

Report
Copy link

Link copied!

Power Apps is saying that 'EmailFieldName' is expecting a text value

Was this reply helpful? Yes No
karolina1406 9 on at

Like (0)

Report
Copy link

Link copied!

This is perfect! Thank you... Can this also be done to create Distinct list of the values? I am using Distinct(Concat(colNotifiers,Email,";" & Char(10))) but it doesn't work 😞

Was this reply helpful? Yes No