Start Flow when Date in Sharepoint list item is reached

(0) Share

Report

Posted on by 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 ?

Categories:

Building flows

All responses (5)

Answers (1)

Sort by

efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!
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 41 on at

Like
a
(0)

Report
Copy link

Link copied!

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 🙂
Verified answer

efialttes 14,756 on at

Like
a
(1)

Report
Copy link

Link copied!
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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 41 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-alzhan-msft @efialttes

Thanks a lot guys!!
Working finde now 🙂