Filter items with query on today error

(0) Share

Report

Posted on by 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?

All responses (8)

Answers (1)

gobi 10 on at

Like (0)

Report

Re: Filter items with query on today error

I am also having same problem

{
"value": []
}
Community Power Pla... on at

Like (0)

Report

Re: Filter items with query on today error

I think you forgot the ' after utcNow
Community Power Pla... on at

Like (0)

Report

Re: Filter items with query on today error

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"
Verified answer

maximvanneste 23 on at

Like (2)

Report

Re: Filter items with query on today error

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.
maximvanneste 23 on at

Like (1)

Report

Re: Filter items with query on today error

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
v-yamao-msft on at

Like (2)

Report

Re: Filter items with query on today error

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 23 on at

Like (0)

Report

Re: Filter items with query on today error

@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 on at

Like (0)

Report
Re: Filter items with query on today error

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