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
Good Day Sir,
I am trying to follow your instructions on setting up a flow to have one of my Choice Columns update based on todays date. Below are screen shots of everything I copied from your post, I would be most thankful if you can find out why I keep getting an error stating my "Status" column doesn't exist.
I particularly want my Status Column to update from 'Completed' to 'On Leave' when the LV Start Column hits today's date.
Any help on this matter would be greatly appreciated, thank you in advance!
Dotson_J check what the internal name of the column is from list settings then edit the column. In the address bar at the top the internal name is after field=
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)RobElliott Good Day and thank you! I went to the column settings and in the URL it said "Field=Category" So I used Category eq 'Completed' and no more error occurred.
Thank you once again!
