Hi everyone, Happy New Year!
I have a SharePoint list.
It has 2 records that have an end date greater than today. I would like those 2 to be included in a daily email. Here's my flow at a high level.
Inside the apply to each loop, the flow is looping through the SharePoint list. I'm asking it append to a string variable called "Employee" if the end date is greater than or equal to UTCNow(). (I actually want it be if the start time is less than or equal to now as well, to show who is off today.)
Anyway, I am using the format for UTCNow() of formatDateTime(utcNow(),'dd-MMMM-yyyy'), and the email that I get returns all 6 records in the SharePoint list.
There must be something going on with my syntax in the condition statement. Any help, as always, would be greatly appreciated.
Solved! Go to Solution.
@smorley , if you just want items which have end date greater than today, one more efficient way of doing this is filtering the items in Get Items action using Filter Query as shown in below example screenshot, this will make performance of your flow efficient. You just need filter query 'EndDate gt 'formatDateTime(utcNow(),'yyyy-MM-dd')'
So many events happening this month - don't miss out!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.