Email based on gallery items

(0) Share

Report

Posted on by StephenGW

583

Hello all,

I wonder if this is even possible? I have a gallery that consists of Contacts, Emails Addresses, a count based on that information, and a boolean also based on that information. I'm wanting to create a button that looks at the boolean Body5_1, and evaluates that for each gallery item. If it is true in a gallery item I would like to send an email to the email address in that gallery item using the other data in the gallery item.

If(Body5_1.Text="true",Mail.SendEmailV3(ThisItem.EmailAddress,"Support Contacts","Hello "&ThisItem.Contact&", You have "&Body5.Text&" support contacts this week. Thanks.",true))

But this will only send the email to the first item in the gallery not each and every one.

Any ideas on how to make it send an email to each gallery item?

Thanks,

Stephen

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!
@StephenGW If you want to send emails to all items in the Gallery, you have to loop through the gallery using a ForAll() loop. Try the following formula,
ForAll(youGallery.AllItems(),If(Body5_1.Text="true",Mail.SendEmailV3(ThisItem.EmailAddress,"Support Contacts","Hello "&ThisItem.Contact&", You have "&Body5.Text&" support contacts this week. Thanks.",true)))
Replace youGallery with the name of your Gallery.
Also, one thing that's not clear is what control is Body5_1? Is it a text input? If you want to display Boolean values, a checkbox would be better. Hope this helps.

Was this reply helpful? Yes No
StephenGW 583 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT

That worked perfectly! Body5_1 is a text box with a formula in it to see if a count is higher than a set number.

Thank you for the solution and quick reply!
Stephen

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@StephenGW Glad to help !😊

Was this reply helpful? Yes No