Forum Discussion
Flow on SharePoint list
Hey Is there someone who can explain how i setup flow in a way that i get todays events from a sharepoint calendar. I want to create a post in Teams that contain today´s events from a sharepoint...
Matt Weston
I hope you can help me with a thing.
You provided me with this formula to extract "todays" events from a calendar.
EventDate ge datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T00:00:00' and EventDate le datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T23:59:59'
How would i change this one to make it extract all events from todays date and 5 days ahead.
So if it is monday morning. I want to extract all events from Monday, Tuesday, Wednesday, Thursday and Friday (5 days).
I hope you can help me with a thing.
You provided me with this formula to extract "todays" events from a calendar.
EventDate ge datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T00:00:00' and EventDate le datetime'@{formatDateTime(utcNow(),'yyyy-MM-dd')}T23:59:59'
How would i change this one to make it extract all events from todays date and 5 days ahead.
So if it is monday morning. I want to extract all events from Monday, Tuesday, Wednesday, Thursday and Friday (5 days).
Hi Oskar Kuus sorry for not replying before now.
There are a long list of expressions that you can combine, just like you would in Excel. To figure out what 5 days are from today, you can use something like this:
addDays(utcNow(),5,'yyyy-MM-dd')