Changing Column Status in SharePoint List

(2) Share

Report

Posted on by Tasturhelden24

Hello,

How can one Power Automate a change in status within a SharePoint List?

In this scenario, I need to change a status based on the date from which the status was created.

Looking forward to any insight.

Categories:

General topics

All responses (5)

Answers (0)

Sort by

Suggested answer

Dominik Stalzer | p... 71 on at

Like
a
(1)

Report
Copy link

Link copied!

Create a Scheduled Flow:

Set it to run at your preferred interval.

Add the "Get items" step for your SharePoint list.

Use the "Apply to each" action to iterate through the items retrieved. Inside this loop, add a "Condition" to check if the date field meets your criteria if it’s for example older than a certain date.

If the condition is met, add the "Update item" action. Provide the ID of the item to update and set the new status value.

Hope this helps.
Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you want to change the status in real-time, like when an item is being updated, or on a daily basis or what?

Dominik has a great foundation below, just checking the time frame or activity that you want to do to trigger the activity or what you need above and that Dominik has asked about.
Tasturhelden24 79 on at

Like
a
(0)

Report
Copy link

Link copied!

In regards to time interval it needs to check daily items older than 30 days and change status.
Tasturhelden24 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Update.

The flow fails at Apply to each. Here is the image of the error that is being produced.

Here are the expressions that are being used currently:

Left: UTCNow()

Is greater than

Right: FormatDateTime(items('Apply_to_each')?['Date Parts Ordered'], 'u')

Trying find the correct condition to use to find dates greater than 30 days from today. This is to change the status field.
Suggested answer

Dominik Stalzer | p... 71 on at

Like
a
(0)

Report
Copy link

Link copied!
You can use FormatDateTime only if the value of items('Apply_to_each')?['Date Parts Ordered'] is not Null.

Add this condition beforehand and check if a value in your list is not null:
not(empty(items('Apply_to_each')?['Date Parts Ordered']))

You can later check the log to see why you have null values. After that, you could optimize your list by cleaning up the null values.