Update choise value in column depending on date

Copper Contributor

Hi,

I am new at sharepoint online and try to figure out how we can usefully implement it in my company.

 

I have a documents lists in sharepoint and I want to make column "Status" change automaticaly depending on three dates: delivered, warrancy, today date. So I have try to make a flow:

NaSpa1315_0-1706620891860.png

Condition is like this ( delivered date>today date)

NaSpa1315_1-1706620919832.png

if true - update item (Status value - "in force"):

NaSpa1315_2-1706621043590.png

 

If false, then condition1 ( delivered date<today date and warancy date>today date):

NaSpa1315_3-1706621113954.png

if true update item to "in warancy", if false update item to "not valid".

 

But my flow failed testing in each step from action "For each":

NaSpa1315_4-1706621452434.png

NaSpa1315_5-1706621505485.pngNaSpa1315_6-1706621532999.png

 

Any ideas how I can fix my flow?

2 Replies
Try using utcNow() instead of TODAY().

Thank you! so much, it works! @tmayrand  Thank you!