Answered

Filter Gallery and send email

(0) Share

Report

Posted on by Silva_BR

Hi everyone, I have a gallery in Power Apps where I do some filters.

I would like to send this gallery filtered by E-mail in HTML.

How to do this? Can you give me some example options?

Thanks!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Matt1405 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you trying to send and email based on the filtered results from a gallery?
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Silva_BR，

Do you want to email with the filter Gallery records?

Could you please share a bit more about your scenario?

Actually, you could achieve this using the HTML text control.

You can make an Html table with the content of the filtered Gallery and send it as the body of the email

I have made a test for your reference.

I set the Gallery Items property as below:

Filter(Actions,!IsBlank(Car))

Add a HTML text box and set the HtmlText property as below:

"<strong> Information: </strong>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>Title</th> <th> ActionID </th><th> ID </th> </tr>" & Concat( Gallery27.AllItems, "<tr> <td>" & Title & " </td> <td>" & ActionID & " </td> <td>" & ID & " </td> </tr>" ) & "</table>"

Add an Button and set the OnSelect property as:

Office365Outlook.SendEmailV2("xxx@microsoft.com","Notify",HtmlText1.HtmlText)
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft

Is there any possibility to send same type of Email with power automate

Thanks & Regards
aricheeju 2 on at

Like
a
(0)

Report
Copy link

Link copied!

While I am adding HTML text for sending the gallery through email using below but it is showing error after adding HTML text... Please give me a resolution to fix this problem...
Set(_emailRecipientString, Concat(MyPeople, Mail & ";"));
Office365Outlook.SendEmail(_emailRecipientString, TextEmailSubject1_1.Text, TextEmailMessage1_1.Text.HtmlText2.HtmlText);
Reset(TextEmailSubject1_1);
Reset(TextEmailMessage1_1);
Clear(MyPeople)