Notifications
Announcements
I need to create a flow to send email report every Monday exporting from Calendar View to MS Excel.
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,
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
