Share
Report
6I have a SharePoint list for maintenance issues. It has a calculated column for 'issue duration', which does a "datedif()" using the Creation date and the "Today()" function. For a particular record, the duration function only gets updated if and when that record gets opened and resaved. As an experiment I made a duplicate list, but with a "todaysDate" column that is populated by a Power Automate scheduled flow. Each morning the flow does a 'get all items' from that column and updates all the records. The calculated column uses todaysDate instead of Today(), so the all items view always shows updated durations.
Now I added a second calculated column, a 'durationUsingFunction" column, which again uses the "Today()" function. I was going to try another flow aimed at that column, but I never got to. The durationUsingFunction column is updating itself every day, without a flow and without opening records. It would appear the the flow which updates the 'todaysDate' column is acting like an open-and-edit on all the records and causing the unrelated calculated column to update. I guess my question is: 'would any scheduled flow operation on the list cause all calculated columns to update? If so which one would be the simplest?'.
Can anyone confirm that the unrelated calculated column update should be happening?
Is there a simplest flow that would do this?
Thanks
All responses (
Answers (
