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 employee's name, start date, end date of leaves and the number of days taken for leave as email's body, supposing that employee's name, start date, end date of leaves is available as event in calendar in an HTML format?
Thanks in advance.
- 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.
3 Replies
- 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. - Hi! As far as I know you have to find the right connector first when establishing a new flow with ms flow. I would suggest a SharePoint calendar list, but it’s in aspic format, not in html.
Can you specify where your content is published? Maybe there is a connector for your list designing html application I don‘t know.
Greets, EvaHI,
My content is getting published in the events of Sharepoint Calendar. Well, I think I understood what my workflow would like. The main challenge is to each event in textual format in the mail body as it is dynamic.
