Convert a Gallery into an HTML Email in Power Apps
Converting a Power Apps Gallery into an HTML email involves extracting data from the gallery, populating it with the data, and ultimately sending it as a visually appealing email to recipients.
In this video we do the basics to get you started. We Collect the Gallery and rewrite it in HTML using a Concat function.
This is the old video this video was based off of: • Beginner Tutorial: How to Write Multiple L...
Collecting Gallery Formula:
Clear(colMyGallery);
ForAll(Gallery2.AllItems,Collect(colMyGallery,{Title:TextInput1.Text,FoodType:TextInput2.Text,Allergies:TextInput3.Text,Calories:TextInput4.Text}))
Email Button:
/*Create semicolon separated list of people to email, send the email, reset subject & message fields*/
Set(_emailRecipientString, Concat(MyPeople, Mail & ";"));
Office365Outlook.SendEmail(_emailRecipientString, TextEmailSubject3.Text, HtmlText2.HtmlText, {Importance:"Normal",IsHtml:true});
Reset(TextEmailSubject3);
Clear(MyPeople)
The HTML Text can not be written to the properties of this video due to Youtube limitations.
Chapters:
0:00 Introduction
2:27 First Step Re-Collect the Gallery
4:00 Viewing & Clearing the Collection
5:00 Using & Editing the Email Screen Template
6:35 Writing our HTML Text based on a Collection
9:57 Setting IsHTML to true
11:00 It works! Conclusion