Power Automate to update Columns only on a SharePoint List daily

(1) Share

Report

Posted on by AmieRobbo

Hi Everyone

New Beginner here. I have tried a couple of automates to which have failed.

I have a Training certificate SharePoint list, however as seen below the "Expired" "Due" "Current" Column are a calculated cell / result of the expiry date column (date formatted)

SharePoint doesn't update at all until the row / column / cell is edited and or updated.

I would like help with updating a whole SharePoint list on a daily basis.

Happy to add date columns, text columns, formula columns if needed.

Can anyone help with a step by step guide on how to achieve this?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Haque 3,217 on at

Like (0)

Report
Copy link

Link copied!
Hi @AmieRobbo,

Seems like you want to update the Statu scolumn daily based on Expiry Date column using PowerAutomate?

These are the steps you can follow to achieve the goal:

Trigger: Use the Recurrence trigger to run the flow daily at a set time.

Get items: Use the Get items action to retrieve all items from your SharePoint list.

Apply to each: Loop through each item returned (from the list)

Condition checks: For each item, compare the Expiry Date with today’s date and update the Status accordingly:

If expiry date is before today → Status = "Expired"

If expiry date is today or within next X days (e.g., 7 days) → Status = "Due"

Otherwise → Status = "Current"

Update item: Update the item’s Status field with the calculated value.

Have basic idea from an old thread. One more is here.

Please let me know if nore technical help is needed.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
Suggested answer

11manish 2,345 on at

Like (0)

Report
Copy link

Link copied!
SharePoint calculated columns don’t auto-refresh

Use Power Automate to trigger updates

Best solution = Scheduled flow + Status column

Power Automate Scheduled Flow (Recommended )

Use Power Automate to “touch” items daily.

How it works:

Create flow → Recurrence (daily)

Get items from list

Loop through items

Update each item (no real change needed, just trigger update)

This forces recalculation of calculated columns

Simple Update Example:

Update a dummy column like:

LastChecked = utcNow()

Was this reply helpful? Yes No
AmieRobbo 43 on at

Like (0)

Report
Copy link

Link copied!

Can you please simplify this further with a step by step?

Was this reply helpful? Yes No