Showing results for 
Search instead for 
Did you mean: 
New Member

Newbie - Emailing Sharepoint List Contents

I'd like to generate a weekly email containing the contents of list (this list shows items up for review).


I've set up a flow with a recurrence followed by a Sharepoint "Get Items" call and then an Apply to Each against an Email.  This obviously isn't doing quite what I want and instead is generating separate emails and the content isn't formatted as I want it.


Is there an easier way to do this?  Otherwise thinking I need to stick with my "Get Items" call, but throw the columns I want into some sort of list of lists and then figure out how to make it look nice.


I really just want the output to look like it does in Sharepoint -- a nicely formatted table.



Community Support
Community Support

Hi @rvandolson,


Please try the action Create HTML table in your flow. More details about this action, please check it at here:


Please take the following screenshot for a reference. Just remember to enable Yes for the Is HTML field in the action Send an email.




Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello,  @rvandolson!

Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (9,960)