Format Email text in HTML format for a single modified record in sharepoint

(0) Share

Report

Posted on by cheezy

148

I have a flow that sends an email based on an item being modified in a sharepoint list.

I would like to format the email content more elegantly using a HTML table.

My flow is essentially:

1. When an item is created or modified

2. Email

So trying to insert a HTML table i have tried

1. When an item is created or modified

2. Get items

3. Create HTML table

4. Email

This send all records from the Sharepoint list not just the single record being modified. I am not sure if this is the correct flow but is there a way of filtering the Get Items to jus the modified record?

Maybe a better way altogether?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @cheezy ,

You can pass ID from your trigger and use Get Item to get the singular record

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
cheezy 148 on at

Like (0)

Report
Copy link

Link copied!

When i pass the ID to the Create HTML

i get a " The 'from' property value in the 'table' action inputs is of type 'Integer'. The value must be of type 'Array'."

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @cheezy ,

Pass ID to Get Item to get a single list item. Refer to my earlier screenshot.

You can then pass the output of Get Item to Create HTML Table

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No