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 ?

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Re: Start Flow when Date in Sharepoint list item is reached

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

Was this reply helpful? Yes No
HelplessMax 41 on at

Like (0)

Report

Re: Start Flow when Date in Sharepoint list item is reached

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 🙂

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report
Re: Start Flow when Date in Sharepoint list item is reached

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

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Start Flow when Date in Sharepoint list item is reached

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.

Was this reply helpful? Yes No
HelplessMax 41 on at

Like (0)

Report

Re: Start Flow when Date in Sharepoint list item is reached

@v-alzhan-msft @efialttes

Thanks a lot guys!!
Working finde now 🙂

Was this reply helpful? Yes No