Two sharepoint lists with same columns but different permissions edition

[ruyandre]

Hi,

I want a flow or flows that create two separate lists, one that is a "master" list with all the fields on it. The second list has a unique lookup columns to the first, and a copy of the two fields you want editable.
A Flow configured for the "master" list ensures modify an item in the second list with the Lookup column pointing to the item that triggered the Flow and update the first list with this value.
The users can edit the fields in the second list, but have no contribute rights to the "master list". Then a Flow configured on the second list copies the values from those fields back to the master list whenever a change is made.

The aim that the two lists are the same columns.

Can you help me?

[v-wenjuan-msft]

Hi @ruyandre ,

So you already have the master list, not what you want to realize is

1. Customize a one-time flow to copy two editable columns and a lookup column into a second list;

2. Customize a automate flow, whenever modifications happens to the second list, same modifications will sync to the master list.

Please correct me if I made any misunderstanding. I will do tests upon your response.

But I wonder if new items are created in the second list, should them be sync to the master list?

Community Support Team _ Wenjuan Zou

If this post helps, then please consider Accept it as the solution to help the other members find it.

[v-peijunz-msft]

Hi @ruyandre 

Do you want to trigger the flow when a field is modified in the second list, update master list with the same value?

If so, maybe you could try the following way:

@not(equals(triggerOutputs()?['body/Created'], triggerOutputs()?['body/Modified']))

To let the user does not have the right to edit field in master list, you could use "Grant access to an item or a folder" action, and grant the roles to Can view.

Here is the link for your reference:

Manage list item and file permissions with Power Automate | Microsoft Learn

Best regards,

Sylvia

[ruyandre]

Yes, I want this two options:

"1. Customize a one-time flow to copy two editable columns and a lookup multiple columns into a second list (not editable);

2. Customize a automate flow, whenever modifications happens to the second list, same modifications will sync to the master list. (and vice versa)"

I included with green color more context.

Thank you.