Forum Discussion
Solved
Add list items to email body using microsoft flow
Hi, I am trying to create a flow for my Account Management team. My task is to iterate through calendar events of employees taking leave every month and then email the Account Management team the em...
- Start with a schedule trigger to run once a month and get list items from the calendar list, I would use a filter to get everything that that is newer than one month from the Flow run, you can use the adddays function and datetime query.
Then use the HTML table build action on the results. You may have to some sorting to get the order right first. There are lots of examples for generating HTML tables in Flow from data in the Flow forum. When you send the email, include the HTML content and set the property to say it's HTML.
Start with a schedule trigger to run once a month and get list items from the calendar list, I would use a filter to get everything that that is newer than one month from the Flow run, you can use the adddays function and datetime query.
Then use the HTML table build action on the results. You may have to some sorting to get the order right first. There are lots of examples for generating HTML tables in Flow from data in the Flow forum. When you send the email, include the HTML content and set the property to say it's HTML.
Then use the HTML table build action on the results. You may have to some sorting to get the order right first. There are lots of examples for generating HTML tables in Flow from data in the Flow forum. When you send the email, include the HTML content and set the property to say it's HTML.