Restricting Column Edit Access on SharePoint Lists

(0) Share

Report

Posted on by martatracik

297

Dear Community,

i am leading a project that collects users requests from PowerApps form and saved them on SP list, then another team changes status of that request and some following actions are taken etc. what i discovered right now is that team CANT change values submitted by requestor and should only change status field. i know it's not possible to have different level permission to columns in SP. what do you recommend right now? i am seriously worried as i've a lot of time on that form.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

HenWang Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @martatracik ,

Understand and just like mentioned in your description, it's always been a difficult question to manage user's access to SharePoint list.

In you scenario, I think you can create a flow to send email to the "another team" you mentioned. You can use either "send email with option" action or the approval action:

Both of them are able to provide the response to flow and you can use update item action to do the update. However, for the connection of this update item action, you can use your own connection, which means the real update action will be done from your side instead of from the "another team", and they do not need to have access to the SP list.

Check connection of update item action:

Best Regards,
Heng Wang

Was this reply helpful? Yes No
Verified answer

martatracik 297 on at

Like (1)

Report
Copy link

Link copied!

thank you, that solution looks very good.
me at the moment i used Power Automate along with Look Up columns.
i created an ID lookup column that connects ID from 1st SP list. in List Setting under that ID column options i selected all additional columns. then i connected Power Automate - once a new item is created or modify as trigger. Obviously it's not a perfect solution as we can select only Single Text Line/ Calculations/Date and Time type columns, and not all columns can be convert to that (Attachments), but at the moment it's enough for me.

Was this reply helpful? Yes No