Filter items with query on today error

[maximvanneste]

Trying to get this flow up and running.

I need it to return the items where 'creation date' equals today.

This is my setup.

Sharepoint list with creation date (UTC +1)

My filter query is this

When testing it, I get this error (means: expression not valid...)

Any help?

[v-yamao-msft]

Hi @maximvanneste,

The Created of a SharePoint list item is returned as ‘yyyy-MM-ddTHH:mm:ssZ’, so in the filter query function, you should format the utcnow likes below:

utcnow('yyyy-MM-ddTHH:mm:ssZ')

In the Filter query field, please surround the function with a single quote.

Please check the following screenshot:

Please have a try with it on your side and feel free reply if you need more help.

Best regards,

Mabel Mao

[maximvanneste]

@v-yamao-msft

Thank you for your answer, the flow seems to work without returnin an error, however when I add a new item it says that the body value is [].
I need it to return all the items from today, could it be that the language plays a roll in the filterquery? 

Kind regards,
Maxim

[v-yamao-msft]

Hi @maximvanneste,

Created is a default column in SharePoint list, so I am afraid that it is not possible to format it in a Odata filter function.

If you want to return all the items on today, please add a custom Date and time (Date only) column in the list, then format the utcnow as “yyyy-MM-dd”.

The function could be configured as following:

CustomCreatedDate eq ‘utcnow(‘yyyy-MM-dd’)’

Please have a try with it on your side.

Best regards,

Mabel Mao

[maximvanneste]

Hi @v-yamao-msft

I created a custom column named 'Datum' and went ahead and changed the flow to this:

When running it I see that the column 'Datum' is '2018-07-17' which is identical to what it should be, still gives me an error?

I feel stupid for not finding this error as I'm prety sure this is easy.

Kind regards,
Maxim

[maximvanneste · Accepted solution]

I made it work with a little work around:

made a query between today and today +1 with the ge and lt

seems to do the trick.

[Anonymous]

I have this same issue. I've spent hours trying all sorts of methods and I can't get it to work. Either it tells me there is no value (which, there is, because I have a fake one with today's date) or it says the flow ran with no issues, but I don't have an email.

I have a list of items and I want to send an email whenever the "sendreminder" field equals TODAY. Any help would be much appreciated!!!

Workflow Overview"Successfully" ran, but I didn't get an emailJust proof that the field is titled "sendreminder"

[Anonymous]

I think you forgot the ' after utcNow

[gobi]

I am also having same problem

{

  "value": []

}