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')'
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.