Start Flow when Date in Sharepoint list item is reached

[HelplessMax]

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 ?

[efialttes]

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

[HelplessMax]

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 🙂

[efialttes · Accepted solution]

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

[v-alzhan-msft]

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.

[HelplessMax]

@v-alzhan-msft  @efialttes 

Thanks a lot guys!!

Working finde now 🙂