Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Weekly report send by email from sharepoint calendar view export to xls

I need to create a flow to send email report every Monday exporting from Calendar View to MS Excel. 

Community Support
Community Support


Hi @alpatel ,


You can use Recurrence as a trigger, and then set Flow to run once a week.


Use the Get items action to get the items in the SharePoint calendar, and configure Filter Query to filter the items created in the previous week.


Configure Excel action to add items to the table.


Best Regards,

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

Hi Barry, 

I created a report as you suggested. I am not able attach in Excel format. i get email in this format as shown below in first screen shot. Second one show i am getting file from onedrive in "Attachment Name -1" as File content. Why this is not converting to xls format in email?






Hi @v-bacao-msft , 

To run last week report, I entered this filter query {[Start Time] lt '@{addDays(utcNow(),-7)}'.

Start Time is column in sharepoint but it seems to be not working. 



Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (45,012)