Hello.
I have an edit form reading from a SPO list.
I have a column called Owner and a choice column called Status and a few other columns too.
I need it so that only the Owner can change the Status. If a non-owner opens the edit form for that item, then they should receive an error message if they try to edit any of the columns. I beleive i can get the person who is loading the form via the
User().Email ?
I tried to do something like the below on the status datacard, but no luck
If(Owner.text = user().email, set(displayMode.Edit) else set(displayMode.View) That line of code didnt work - but i hope you get the jist of what i am trying to do, also, how can i add a warning if a non owner tried to edit?
Can someone help me pleasE?
thanks.