User Profile
EA17123
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Sharepoint Online list calculated column with todays date not updating automatically
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 ! EA26KViews0likes0CommentsRe: Sharepoint Online list calculated column with todays date not updating automatically
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 !26KViews0likes2CommentsRe: Sharepoint Online list calculated column with todays date not updating automatically
Hi all, hi ganeshsanap , I am facing a situation where my calculated column is using the field ID (unique number of the item in my list). For safe of clarity and simplicity : - I created a column named UID, as calculated column - below is the (very) simplified formula I am using, in order to express the issue =ID The behaviour is the following : - when the formula is modified, the modification are populated to all items - when an Item is created or modified, the result is '0' Could you please advise how I could reuse the ID and make sure everytime an item is created or modified, the formula is properly executed ? Thanks in advance EA28KViews0likes4Comments
Recent Blog Articles
No content to show