List modification approval

EKIT415 

Hi again, thanks for your reply and information.

It was actually an nice case and made me reconsider some of my own flow designs. I will put this case in a vlog which am preparing.

Some assumptions:

• A user must be able to create an item without approval
• A user must get an approval when he/she changes an item
• You as a list owner must be able to roll back to the previous values of an item

Initial testlist

• Test user Athena and member of site (and therefore edit access to list)
• Me as owner (user Roy Drissen) having full control
• The list has a hidden column 'Approved' which is a boolean
• When owner modifies approval is not necessary 

Let's start

I will let you take part in my thinking process.

The solution with an old value column only really works when only 1 or 2 columns are in the scope of change. So forget about that one. So I though, let's use version history. Given above assumptions I started to make some 'code' for an automatic flow.

You can get the major version using

 int(first(split(triggerOutputs()?['body/{VersionNumber}'],'.')))

Then I ran into several checks which are required to meet the conditions (red: assumptions mentioned above)

Additionally

Then I started to think : this wil become very complicated and probably need to make a locking mechanism to prevent other users to change the item involved. I am actually doing things which SharePoint can do for us. So I looked in the  settings and check out the next settings:

This comes close to the functionality you want, without programming anything at all. Users need to be familiar with versioning or you as an owner must restore the version. Additionally you can control who is able to see draft versions.

I hope this is any help.

Alternatively, if you want to resolve this in Power Automate you need to work with a duplicate list.

One list you allow users to make changes via an instant flow (list is read only)

Second list to keep track of changes by using the instant to copy draft items. 

This will require some special permissions and will become a bit more complicated.

Any reflexions on this?

Roy