cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MarkW1
Level: Powered On

Comparing dates in a GetItems container to filter the returned list

 

Hi team,

After banging my head to desk for a few hours I'm now seeking expert help. I am creating a flow to run daily to email job vacancies that expire on the current day. Having worked with databases for years I know the got ya on dates and datetimes. So my list has two fields at the moment, Title and TriggerValue. TriggerValue is a date only field. I have my recurrance container, then a getitmes (as there could be 0 or more in the list that I need to get) container. In the GetItems I have the site and the list name. I then want to add a filter to say only when triggervalue = today.

This is what I have tried (plus a variety of other formats)

formatDateTime(item()?['triggervalue'], 'dd-mm-yyyy') eq formatDateTime(utcnow(),'dd-mm-yyyy')

and @equals(@formatDateTime(item()?['triggervalue'], 'dd-mm-yyyy'), @formatDateTime(utcnow(),'dd-mm-yyyy'))

and @formatDateTime(item()?['triggervalue'], 'dd-mm-yyyy') eq @formatDateTime(utcnow(),'dd-mm-yyyy')

 

Please help me get a date filter into the GetItems and then I can finish testing the flow to see that the email is sent as expected

2 REPLIES 2
Community Support Team
Community Support Team

Re: Comparing dates in a GetItems container to filter the returned list

Hi @MarkW1,

 

You need to change the format to 'dd-MM-yyyy', for 'mm', it stands for the minutes.

If here you would like to fitler the Get items table with workflow definition language, then we could take use of the filter array action, then copy and paste the following formula into the condition advanced mode:

@equals(formatDateTime(item()?['triggervalue'], 'dd-MM-yyyy'), 
        formatDateTime(utcnow(),'dd-MM-yyyy'))

If you would like to work with the Filter Query option within the Get items action, then the format should be:

Column eq value

 

There is no function available that could format the date string from sharepoint into a whole time string, so for your situation, please consider switch to the format below:

DateTime ge '2017/6/10'

 

My testing results shows that it seems currently the SharePoint Get items aciton don't support the dynamic value.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MarkW1
Level: Powered On

Re: Comparing dates in a GetItems container to filter the returned list

Thanks v-micsh-msft. It does appear that I can't pass in the field value to the OData query which is frustrating as it now looks like I need to pull the whole list and then filter in the loop to only select the items where the date = today.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,652)