Calculated Column in SharePoint List is not updating with flow when run automatically.

Like (0) Share

Report

Posted on 13 May 2024 08:30:01 by SR_dataguy

Hi,

I've a MS List in which there are two date columns. I've a calculated column which is dependent on these 2 date columns and it also contains Today() in its formula. So everyday the values have to be updated. So, I've setup a Power Automate flow. When I test manually, values are get updated. I thought the flow is working fine. the trigger is Occurence (Every day 5:30 AM) and when I checked next day, fklow ran successfully and in MS list Modified date is also changed. But values in calculates column are not updated. Then, I did Manual test, then values are updated.

Screenshot 2024-05-13 135752.png

So, why SharePoint list is getting updated for Manual test but not for Automatic flow run? And how to make Automatic flow updates the list?

All responses (1)

Answers (0)

David_MA 11,042 Super User 2025 Season 1 on 13 May 2024 at 16:37:24

Like (0)

Report
Re: Calculated Column in SharePoint List is not updating with flow when run automatically.

Calculated columns do not refresh when a flow updates columns. You need to physically open the item and submit it again to refresh the calculated columns. If you want to do this with a flow, you will want to replace the calculated column with a column of the data type that is calculated, and then calculate and populate the field in Power Automate.

Depending on what you are doing, you may be able to use JSON formatting in your list to achieve what you want. For example, this will calculate the number of years on a date field:

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(Number(@currentField) == 0, 'N/A', '@currentField.displayValue' + ' (' + floor((Number(@now) - Number(@currentField)) / (31536000000)) + ' years)')", "style": { "border": "none", "background-color": "transparent", "cursor": "pointer" } }

It will show up in your list as:

JSON calculates in real time and doesn't require you to open the item to refresh the value.