Power Platform Community Forum Thread Details

Hi,
I want to send email to the assigned trainers from the gallery. Now as shown in this screenshot I have 2 trainers assigned now the email should include start date, end date and time mentioned in the gallery

( for 1) Aditya - Start Date:9/8/2021 End Date: 9/9/2021, Start Time : 9:00 AM End Time : 18:00PM

2) Ashwini Start Date:9/13/2021 End Date: 9/16/2021, Start Time : 9:00 AM End Time : 18:00PM).

So how can I send email to these assigned trainers with particular Start Date, End Date, Start Time and End Time.

Categories:

Building Power Apps

Hi @svramkuna ,

Since I don't know the data source of the Gallery, assuming it is a collection generated from the Update button, I made a simple test to explain:

1\ I created a demo list '11' with several columns in your gallery, Title represents the Trainer column:

2\ In Power Apps, I created nested Galleries with items set to:

GroupBy('11',"Title","Grouped")

3\ OnSelect of a button I set to below to create a collection that includes all information for you to send emails :

Clear(col12123);
ForAll(
 GroupBy(
 '11',
 "Title",
 "Grouped"
 ) As G,
 Collect(
 col12123,
 {
 T: G.Title,
 StartDate: First(G.Grouped).Dates,
 EndDate: Last(G.Grouped).Dates,
 StartTime: "9:00 AM",
 EndTime: "18:00 PM"
 }
 )
)

4\ With another button, you could set to:

ForAll(col12123 As C, Office365Outlook.SendEmailV2(To:C.T,...))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community site session details

Send Email

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates