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
EA17123 You can use update item action to update the same list item. To avoid infinite loop for flow run, you can use Trigger conditions from settings of trigger (when item created or modified). Use formula like:
@equals(empty(triggerBody()?['UID']),true)
Follow steps given here for adding trigger condition: Trigger Condition when specific fields are not empty
Please consider giving a Like if my post helped you in any way.
Thank you very much ganeshsanap
It worked very well
1. I am facing a new beginner situation.
Let's say my Items has a mandatory field "Title", and and optional field "Content"
While I set-up the "Element update", I have to fill the "Title" field (marked with a * as mandatory).
I am using the dynamic content 'Title'.
But, this creates an infinite loop, because the update of the field 'Title' is not par of the Trigger conditions to stop the loop.
Do you know the trick to avoid this ?
2. Do you know how to set-up a field in ReadOnly ?
The reason is that UID will be automatically computed by the PowerAutomate. Therefore, I want to avoid tentative of filling this text field.
In the properties of the TextField, I can't see any way to do so.
A workaround would be to leave the cell as "calculated column type", but then I don't see the column within PowerAutomate in order to update it... 🙂
Thank you so much for your help !
EA