Hi,
I need to make monthly and YTD reports of my team`s activities which we all log in our Outlook calendars.
Is there a way to make FLOW add a row (with desired fields) to Excel wookrbook for every new appointment in Outlook?
Looking forward to your suggestions.
Many thanks and BR,
Hrvoje
Solved! Go to Solution.
Hi @hjenei ,
Do you want to get all the events from Outlook calendar within a specific time range then insert them into an Excel table?
Before starting the flow, please create an Excel table with the fields you want and upload it to a cloud storage account, I am using OneDrive for Business.
Start the flow with a Button trigger, which could be replaced with a Recurrence button for your scenario.
Then Get calendar view of events (V2), set the Start time and End time separately with the following function:
utcNow() addDays(utcNow(),7)
Add the action add a row into a table, with dynamic content for corresponding fields.
Best regards,
Mabel
Hi @hjenei ,
Do you want to get all the events from Outlook calendar within a specific time range then insert them into an Excel table?
Before starting the flow, please create an Excel table with the fields you want and upload it to a cloud storage account, I am using OneDrive for Business.
Start the flow with a Button trigger, which could be replaced with a Recurrence button for your scenario.
Then Get calendar view of events (V2), set the Start time and End time separately with the following function:
utcNow() addDays(utcNow(),7)
Add the action add a row into a table, with dynamic content for corresponding fields.
Best regards,
Mabel
User | Count |
---|---|
89 | |
81 | |
46 | |
29 | |
24 |
User | Count |
---|---|
37 | |
30 | |
27 | |
22 | |
18 |