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...
You can do this using the Recurrence trigger. The add the actions to get the Items that you want from your SharePoint list and post the message to Teams.
Yes i am using a recurrence trigger.
I get the items from the list. But i do not know how to filter the items so i only get Todays events from the calendar.
Do you mind showing an example where i extract only todays (for example) 5 events and exclude the events tomorrow and yeasterday.
Those 5 events from today should be put into One post in Teams.
I get the items from the list. But i do not know how to filter the items so i only get Todays events from the calendar.
Do you mind showing an example where i extract only todays (for example) 5 events and exclude the events tomorrow and yeasterday.
Those 5 events from today should be put into One post in Teams.
Hi Oskar Kuus see how you get on with those screenshots as a basic guide. You'll need to do some formatting around the post and make the query dynamic, but it should get you pretty much there.
- Thanks
Ill have a look at this tonight.
I have tho a question.
The filter query in picture 2.
That state the date of today... I mean that this flow should be triggered every day and only post "todays dat" (the date oft the day the flow is triggered)
Is this possible?Hi Oskar, sorry it's taken me a couple of days to get back to you. Were you able to solve this?
Just in case, yes I hard coded the dates into the query, however you will be able to use expressions instead to pull out and format the date as required. See my screenshot as to where I've used it. The expression looks like this:
formatDateTime(utcNow(),'yyyy-MM-dd')
Sure thing, I'll see what I can put together now.
