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
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


Fausto Capellan, Jr


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

Proud to be a Flownaut!


View solution in original post

2 REPLIES 2
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


Fausto Capellan, Jr


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

Proud to be a Flownaut!


View solution in original post

CindyBelgium
Level: Powered On

Re: problem with flow expression

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
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,124)