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)
 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 113 members 4,913 guests
Please welcome our newest community members: