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

problem with flow expression

I have made a flow and have doen a filterquery for "getting items":

 

Datum Broodje? equals 'fx utcNow(..)

with utcNow in d-M-yyyy because the date in my SharePoint List is called Datum Broodje? and looks like 6-5-2019 (so d-M-yyyy).

 

But is does not work?

See below (is in Dutch, sorry)

dates flow.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: problem with flow expression

Hi @CindyBelgium 

Change your Filter Query to: 

Datum Broodje? eq 'utcNow(..)'

Also, check the internal name of your Datum Broodje? column. If it has spaces, set the Filter Query to:

Datum_x0020_Broodje? eq 'utcNow(..)'

Please test it and let us know.

 

Regards,

Fausto Capellan, Jr





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


2 REPLIES 2
Highlighted
Super User
Super User

Re: problem with flow expression

Hi @CindyBelgium 

Change your Filter Query to: 

Datum Broodje? eq 'utcNow(..)'

Also, check the internal name of your Datum Broodje? column. If it has spaces, set the Filter Query to:

Datum_x0020_Broodje? eq 'utcNow(..)'

Please test it and let us know.

 

Regards,

Fausto Capellan, Jr





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


CindyBelgium
Level: Powered On

Re: problem with flow expression

it still does not work Smiley Sad
the error message is:
 
"status": 400,
"message": "De expressie Datum_x0020_Broodje? eq ' 7-5-2019' is niet geldig.\r\nclientRequestId: aa3dada4-9e24-4a1a-90b0-9f27d49d4587\r\nserviceRequestId: c942da9e-e092-0000-64bd-b40245fdd2af"
 
Couls the reason be the space between ' 7 ? But I wrote utcNow('d-M-yyyy') so without space.
Maybe I should change the date in the table? How do I do that (so that I do not only change the visual)
 
>