A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Sharepoint expression syntax help - mitigating infinite loops
Hi All!
I have a list, and I want to create a workflow that checks the "Status" column of a new record in the list to see if it has been set to "Send for Approval". When this logic is met, I want to send an approval email to a name listed in the same record. Once the approval is returned, I want to update the record with the Approve/Reject choice from the approval email, along with any commentary the approver might have recorded in the approval email response.
I've seen ways to avoid the infinite looping when checking for changes in a record and modifying it, and I don't want to use the service account open. So I followed the advice on this link to create a hidden data column in the list called "FlowModified": https://medium.com/@gurdevluck/prevent-infinite-loop-in-microsoft-flow-power-automate-b3cf9d764926
I've also used the expression the advice provides, however it just won't work, and I've entered the expression from scratch as well.
@not(lessOrEquals(tick(triggerBody()?['Modified'],ticks(addSeconds(triggerBody()?['FlowModified'],10))))
Please can someone help me solve this?
Thanks,
Steve
Microsoft 365 and Office | SharePoint | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.