Send e-mail with filtered content

[Anonymous]

Hi guys,

I have an app that I input data from a form to a sharepoint list and create a Gallery with it.

The app has 2 filters, one of date and one of status. I'd like to create button that sends an e-mail with the content of the filtered data only.

Is it possible? I've been trying to use the "Gallery1" within the HTML code of the e-mail but with no success. Is there a better way to do it?

Thanks in advance!

Best Regards,

Gabriel

[v-bofeng-msft · Accepted solution]

Hi @Anonymous :

Do you want to send emails based on the content in the gallery?

I've made a test for your reference:

Office365Outlook.SendEmail(
    "XXX@XXXXXX.com",
    "Subject",
    Concat(
        YourGallery.AllItems,
        "<Div>" & 
        "<p>" & Column1& "</p>" & 
        "<p>" & Column2& "</p>" & 
        "<p>" & Column3& "</p>" & 
        "</Div>" & "<hr>"
    ),
    {IsHtml: true}
)

Best Regards,

Bof