Restrict access to a specific column in a share point list

(0) Share

Report

Posted on by Ahmed2

Hello

I have a share point list, and a related flow that sends an email when a specific column is modified.

is there a way to limit and specify who can modify this column?

or a way to see if the modification was done by some one not allowed, to update the fields to the previous value?

i tried by adding an update item action at the end of my flow to do the 2nd option, using a condition loop in an apply to all, but the condition is false so it updates the item, and its true in anothe rpart of the loop, so the email is still sent

does any one have a solution?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Ahmed2

SharePoint does not support column level security. You can make it difficult for a user to edit a column using a variety of techniques but a user who really wanted to edit a column could still figure out a way to edit the column.

If your Flow runs when an item has changed and you know that your column has changed, then just check the modified by field which is actually a person or group column.

Let me know if you have additional questions.

Was this reply helpful? Yes No
Ahmed2 81 on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer
thanks a lot for the info.
i will take you suggestion then.
but is there a way to add an action to then reverse the change done, if the "modifies by" no the one allowed?
i tried update item with a loop condition, but it misbehaves.
so you have any suggestions?

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

There is no way to "undo" what is done.

You'll need to find the value of the column in the previous version (this assumes that versioning is turned on) and update the item. That takes some work. Here is a link to a blog post that will get you most of the way there.

Note that the modified by will then show as you because your connection info was used to update the item.

Was this reply helpful? Yes No
Ahmed2 81 on at

Like (0)

Report
Copy link

Link copied!

hi @ScottShearer
Thanks a lot, i was able to achieve the objective using list versioning to check changes, and using update item .
have a good day

Was this reply helpful? Yes No