Hi everyone,
I'm struggling with specific logic in building an approval flow in Power Automate:
Requirement
We have a SharePoint list in which end-users are meant to make modifications, though an approval flow is required to approve any list modification.
Problem in Power Automate
I have built up the approval workflow, works fine when the list modification is approved. The logic I am struggling with is the following (trying to explain step-by-step below):
1) As soon as a modification is made in the SharePoint list (despite it having an approval flow in Power Automate), the modification is made effective on the list. This is fine if the value change is ultimately approved, not so when rejected. If the requested modification is rejected, the value on the list should be reverted back to the pre-approval value.
2) Therefore we have a secondary (hidden) SharePoint list holding the 'master' version of the SharePoint list, which is only to be updated when a list modification is approved
3) If the approval is ultimately rejected, I am trying to apply the following logic:
- Get all values from a secondary SharePoint list (holding same list data, including all approved list changes)
- Match the item that was under approval from the primary SharePoint to the secondary SharePoint list
- Revert the item for which the approval was rejected back to its original value(s) (as the requested modification is rejected, thus the value changes made should be reverted, and no longer effective)
My question
Am I missing something here, or would I need to work with a secondary SharePoint list to make the above logic work? Hoping there is an easier way to get this working. Would greatly appreciate your input on this!
