Forum Discussion
Sharepoint Online list calculated column with todays date not updating automatically
Anzil375 you would need to use a flow in Power Automate to loop through the list and do the calculations on each item. The trigger would be a recurrence schedule trigger. But it couldn't update a calculated column so you'd need to make the column for the number of days a number column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Hi RobElliott
Thanks - I am setting up a flow per your suggestion. I only have 11 items in there at the moment but it could grow significantly over time. How do I set the update to "all" (e.g. *)? I'm trying to get this to update daily (and to re-calculate all items on a daily basis).
Thanks in advance
nickchoy you can't use the update item as your first action after the trigger as the flow has no idea what item(s) you are trying to update. You would need to use a get items action, preferbly with a filter query to limit the results that are returned. Then based on that inside an apply to each you would update the item.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Hi RobElliott
I have created a quick flow like below:
> Recurrence
> Get items (Site Address, List Name)
> Apply to each (value)
But it is not refresing the whole list including calculated column
Would you mind telling me what I am doing wrong
Thanks a lot
