Forum Discussion
Flow on SharePoint list
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')
Hi
Thanks for your reply.
No so far i have not solved this.
I tried this setup and got the following error
{
"status": 400,
"message": "Kolumnen starttid finns inte. Den kan ha tagits bort av en annan användare.\r\nclientRequestId: 0c5623f7-909f-488c-bb89-ef684d79683f\r\nserviceRequestId: ab1c8d9e-4023-0000-202a-36848dfe84d1"
}screenshot: http://prntscr.com/ksf2k0
The error is in swedish, but translated it says "column starttid does not exist. It can have been removed by another user....
But if i go to my calendar
I clearly see the column is there and it got the correct name.
screenshot: http://prntscr.com/ksf3cz
