Forum Discussion
Update a choice column based on date
Torbjorn_Andersson the flow to do this is as follows and in this example we will change Alison Krauss from New Hire to Working as she starts today:
The flow will run once a day at 8am:
We get the items from the list where the Status is 'New Hire'
Format today's date with a Compose and the expression formatDateTime(utcNow(),'yyyy-MM-dd')
As we've used Get items, add an apply to each and inside it add another Compose control and get the start date then format that with another Compose control and the expression formatDateTime(outputs('ComposeStart'),'yyyy-MM-dd')
Next, add a condition to check if the output of the ComposeFormatStart is equal to the ComposeToday:If it is, update the Status value to Working:
And this is the result:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Torbjorn_Andersson the flow to do this is as follows and in this example we will change Alison Krauss from New Hire to Working as she starts today:
The flow will run once a day at 8am:
We get the items from the list where the Status is 'New Hire'
Format today's date with a Compose and the expression formatDateTime(utcNow(),'yyyy-MM-dd')
As we've used Get items, add an apply to each and inside it add another Compose control and get the start date then format that with another Compose control and the expression formatDateTime(outputs('ComposeStart'),'yyyy-MM-dd')
Next, add a condition to check if the output of the ComposeFormatStart is equal to the ComposeToday:
If it is, update the Status value to Working:
And this is the result:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Dear Rob,
I am trying this flow as well. I want status Up to date (when todays date is before end date) and status Expired (when todays date is after end date). See example below. I managed to create the flow expired, but Up to date is giving error.
I used formatDateTime(outputs('ComposeEnd'),'yyyy-MM-dd') in stead of ComposeStart. Why is it not working?
The flow works, because status changes to Up to date. But Microsoft tells me run failed, but see image, only checks.
Thank you in advance for your help.
Kind regards.
