cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CindyBelgium
New Member

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
faustocapellanj
Memorable Member
Memorable Member

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

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

2 REPLIES 2
faustocapellanj
Memorable Member
Memorable Member

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

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

View solution in original post

it still does not work 😞
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)
 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (16,639)