Forum Discussion

NaSpa1315's avatar
NaSpa1315
Copper Contributor
Jan 30, 2024

Update choise value in column depending on date

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:

Condition is like this ( delivered date>today date)

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

 

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

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":

 

Any ideas how I can fix my flow?

Resources