Hello, I have a ref-type column that opens as a dropdown. The first item that appears before the data is the “new” option. I want this option to appear for administrators but not for other users. Is this possible? Thank you in advance for your assistance.
Please create a read only slice on the reference table. Please use this slice name in the reference column under the reference table name setting instead of the table name.
Edit: Sorry, I missed the requirement that you wanted admin user to add the records. Please ignore the suggestion above and try the suggestion mentioned below
You can manage who can add/ edit/ delete records of a table at the following setting called table settings.
Your " Are updates Allowed" expression can be something like
SWITCH(USEREMAIL(),
“admin@email.com”, “ALL_CHANGES”,
““UPDATES_ONLY””)
Here “admin@email.com” is the email of the admin user. Please have this expression in the reference table.
The above is sample expression. You may need tweaks based on actual requirements for various users in your app.
Please read teh following help article
1 Like
Hi, thank you very much for your time. I made the suggested adjustments. When the user is ADMIN, everything works fine. But when the user is not ADMIN, the column (Ref type) that opens as a dropdown does not show up
Please share the expression you are using, of course by substituting actual emails with pseudo emails
Hi, I used this expresion, SWITCH(
IN(
ANY(
SELECT(Employee[Rol], [Email] = USEREMAIL())
),
{“Admin”}
), “Admin”,
“ALL_CHANGES”,
“UPDATES_ONLY”
) and now the app is working perfectly. Thank youuuu
1 Like
Great. Thank you for the update.