cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HelplessMax
Helper I
Helper I

Start Flow when Date in Sharepoint list item is reached

Hello there,

 

i have a SP List with the column "Fälligkeitsdatum (due date)".

The column has the German date format (23.03.2020)

All i want is a flow that starts when that exact date has been reached.

I have watched many videos and tried multiple things but my formula for te filter query doesnt get any items...

"F_x00e4_lligkeitsdatum eq '@{formatDateTime(utcNow('dd-MM-yyyy'))}'"

 

Can someone please help me ?Flow.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Wait wait wait


 

"status": 400,
"message": "Der Ausdruck \"F_x00e4_lligkeitsdatum eq '2020-03-23T00:00:00.0000000\" ist ungültig. Creating query failed.\r\nclientRequestId: fa1cad7e-846f-49ff-8339-2e4994e5579c\r\nserviceRequestId: fa1cad7e-846f-49ff-8339-2e4994e5579c"
}

Now you shared the error text, the reason seems more clear. Yo see the date format includes time, right?

It looks like the ODAta filter had a typo, so format requested shall be out of utcNow(). Try either with

 

F_x00e4_lligkeitsdatum eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')} 

 

or

 

F_x00e4_lligkeitsdatum eq '@{formatDateTime(utcNow(),'dd-MM-yyyy')} 

 

 Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

5 REPLIES 5
efialttes
Super User
Super User

Hi!

Did you already tried with

 

F_x00e4_lligkeitsdatum eq '@{formatDateTime(utcNow('yyyy-MM-dd'))} 

 

instead?

 

If problem persists, in order to get the right expression to filter, I think it is easier to remove temporarily current ODATA Filter from your 'Get items' and add a 'Filter Array' action block instead just after 'Get items'.

So you shall assign 'Get items' output as 'Filter Array' input, and then play with 'dynamic content' in 'Filter array' condition rule

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Thx for your quick response!!!

Sadly its not working:

 

"status": 400,
"message": "Der Ausdruck \"F_x00e4_lligkeitsdatum eq '2020-03-23T00:00:00.0000000\" ist ungültig. Creating query failed.\r\nclientRequestId: fa1cad7e-846f-49ff-8339-2e4994e5579c\r\nserviceRequestId: fa1cad7e-846f-49ff-8339-2e4994e5579c"
}
 
I will try the filter array now, will update you asap 🙂

Wait wait wait


 

"status": 400,
"message": "Der Ausdruck \"F_x00e4_lligkeitsdatum eq '2020-03-23T00:00:00.0000000\" ist ungültig. Creating query failed.\r\nclientRequestId: fa1cad7e-846f-49ff-8339-2e4994e5579c\r\nserviceRequestId: fa1cad7e-846f-49ff-8339-2e4994e5579c"
}

Now you shared the error text, the reason seems more clear. Yo see the date format includes time, right?

It looks like the ODAta filter had a typo, so format requested shall be out of utcNow(). Try either with

 

F_x00e4_lligkeitsdatum eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')} 

 

or

 

F_x00e4_lligkeitsdatum eq '@{formatDateTime(utcNow(),'dd-MM-yyyy')} 

 

 Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi @HelplessMax ,

 

Please take a try with @efialttes's suggestion that you should format the datetime now to date type.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

@v-alzhan-msft  @efialttes 

 

Thanks a lot guys!!

Working finde now 🙂 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,806)