Announcements
I have a requests, to where requestor wants form fields to be hidden until a team of end users access the form.
Is there a way to have the visible false until certain people access the form?
You can use their EntraObjectID to get the user's unique ID, and check that against a list that defines those authorized users.. You'll have to store the IDs of those who are allowed to access the form.. Either in the app, or in a table somewhere..
Then set the form's Visible property/properties to something like this
User().EntraObjectID in colAuthorizedFormUsers.EntraObjectID
I was thinking something like
field(s) visible = false
based on Users email address becomes true if it is like where the email address is in code like belowWhere I can set the visible as
User().Email="first@company.com"||User().Email="second@company.com"
What I'm trying to figure out is where or how to I capture the End users email address, what is the code for the Visible.
just trying to figure out the switching visible true/false setup
Hey @SPS-DEV-22 ,
you can access the visible property of the field and set it to something like
@SPS-DEV-22 You can use email.. Your formula would work in the Visible property of any control..
I suggest putting what needs to be hidden inside a container, and set the visible property of that container to your User().Email formula..
The 'Or' (||) clause should be used in between each expression. You could also do something like this:
With( { _authUsers: [ "Email1@Host.net", "Email2@Host.net", "Email3@Host.net" ] }, User().Email in _authUsers )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional