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 Unfortunately, this is not possible using calculated column.
You have to customize your list form using Power apps to update UID column with the ID of list item after submit form function.
OR you can use simple power automate flow which will run on item creation in list and update UID column with the ID of list item using "Update item" action.
Please consider giving a Like if my post helped you in any way.
Hi ganeshsanap
Thank you for your answer.
I tried to implement a Power Automate,
- trigered when a sharepoint element of the list is added or modified,
- with the action to update this an element
I understand this is not intended to update the CURRENT ELEMENT that have been modified or added, but another element (possibly from another list.
By the way if i try to update from the same list, I have a warning message indicating this will perform an infinite loop...makes sense...
How to update the UID field of the item that has been triggered as created or modified ?
Thank you for your support, I am beginner, not to say rookie with these tools.
Best
EA !
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