22
Hello, Please suggest if i would like only Admin Role able to edit form. Another question, can i lookup the Role from Office365Users instead of create a Datatable?
DataTable : RexUsers
Column : Email, Role
Below is the formula i have tried:
Set(varRecord, LookUp(RexUsers,Email = varUser.Email));
If(IsBlank(varRecord),EditForm(StockCard1));
Navigate(StockCard);
Thank you.
Ok I assume you are defining users and roles in that table, but it is limited to a single role? If it is you could use the below:
Set(varUser, LookUp(RexUsers, Email = User().Email, Role = “Admin”))
Set(isAdmin, If(IsBlank(varUser), false, true));
On your form’s FormMode property set the following value:
If(isAdmin, FormMode.Edit, FormMode.View)
Yes you can use Office365 Users to retrieve user data, if you have the permissions to add new fields to it you could do that, but personally I would rather make a local list of only Administrators of my app and when the user logs in, check to see if their email shows up in my admins list.
Share
Report
All responses (
Answers (
