Unanswered

Comparing dates in a GetItems container to filter the returned list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No