hi - with SharePoint as my data source if I have contribute access to a record I can edit all the columns for that record. There is no granular locking down of specific columns. You could however block quick edit and force the sharepoint form to be a powerapp, then in your power app show hide fields, adjust display mode properties based on the user or item status to achieve what you are looking for. Another option would be to break your lists down so there is a parent item and child items - then allow people to edit the items they have access to.. like a relational database. Hope this helps.
It locks like the whole item, is it possible to lock specific columns instead of the whole item list using power automate?
hi - with SharePoint as my data source if I have contribute access to a record I can edit all the columns for that record.
There is no granular locking down of specific columns.
You could however block quick edit and force the sharepoint form to be a powerapp, then in your power app show hide fields, adjust display mode properties based on the user or item status to achieve what you are looking for.
Another option would be to break your lists down so there is a parent item and child items - then allow people to edit the items they have access to.. like a relational database.
Hope this helps.