How to restrict users from Editing certain fields?

(0) Share

Report

Posted on by simms7400

829

Hi All -

I have a PowerApps with a user community of about 200. There is a new requirement to add a field that is to be edited by a certin subset of people (say 5 people).

However, these 5 people should be RESTRICTED by editing ALL OTHER fields. While it's OK for the majority f the end user community to have edit access to this new field.

Is there a way I can add logic to all the fields the 5 people SHOULD NOT edit? Can I put them in a group and then have logic that rads the users in the group on app start and cmopares with the current user? Something like that? Or do I have to maintain a collection/list somewhere with these users?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @simms7400

The way I would approach this requirement is to use the DisplayMode property of the these fields in your app. You can set the DisplayMode to Disabled or Edit for the fields that you want to prevent users from editing, and use a condition based on the user’s email or role.

If( CountRows( LookUp( Datasource, User().Email = Email ) ) > 0, DisplayMode.Edit, DisplayMode.View )

This mean that you need to a collection or table to replace with Datasource where the 5 members email is stored.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you! I'm running into an issue though. It's saying this code is expecting a table value instead?

If( CountRows( LookUp( RATIO_Team, User().Email = "test_User@domain.com" ) ) > 0, Set(RATIO_Flag,true) )

I'm using a hard-coded email to test for now. Any ideas?

The other thing to mention is my data source has two Columns, "Name" and "Work_Email" and I have setup as Person or Group to make population easier. Is that not allowed?

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @simms7400

The LookUp value only return one record please change the Countrows to !isBlank:
If( !IsBlank( LookUp( RATIO_Team, User().Email = "test_User@domain.com" ) ), Set(RATIO_Flag,true) )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No