Hi there,
I have a SharePoint list that collects initial review dates, final review dates, and other pieces of information for various records. I have created 2 flows, one for the initial review date and one for the final review date. The initial review date should only update once when the record reaches a specific record status. The final review date should update multiple times as the record status changes over time.
I am having some trouble with the initial review date flow. I tried using a trigger condition such as "@equals(triggerOutputs()?['body/{VersionNumber}'],'2.0')" on the trigger step "When an item or a file is modified", but this does not account for the circumstance of the record being edited before the initial review date should be set.
Is there a way to have a flow only trigger once for a record within a SharePoint list? Any other ideas or suggestions are greatly appreciated.
