Update calculated sharepoint list column with HTTP request.

(0) Share

Report

Posted on by Oelshamy

Hi to Power Automate Community,

I have a list that contains a target date and i have created a Due calculated column, the formula calculates the days difference between today and target date, I need to refresh it every day regardless i open the list or no.

Below is How I configured it through HTTP Request, it runs without issues but the due days number is not being updated.

Can you advise what is wrong?

Capture.JPG

All responses (1)

Answers (0)

Pstork1 65,946 Most Valuable Professional on at

Like (1)

Report

Re: Update calculated sharepoint list column with HTTP request.

You can't directly update a calculated columns since the value is determined by the calculation after an edit has been made to the list item. You can try using a REST call to change one of the values in the list. That should trigger a refresh of the calculated column after the change is saved.