How can I restrict specific field values to specific users

(0) Share

Report

Posted on by Joshua Green

Hi,

I am looking to have one field where users in different teams can access different values.

In our case this is a field say x that has the values a,b,c,d,e. I want Team 1 to be able to access the values a,b,c. But I want team 2 to access the values d and e. To my knowledge, this can only be done using custom scripts. I was wondering if there is any way to segment the values specifically by teams.

Otherwise, our only option is to have multiple fields each for individual teams. and this then makes it difficult for our teams to manage the schema fields when building reports in power BI so preferably we want to use this one field for multiple teams as we would have lots of different fields to manage.

Thanks

All responses (1)

Answers (0)

Suggested answer

Ran Zhang Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi Joshua,

Not sure if we can use below API to do so after checking team's access:

formContext.getControl(arg).removeOption(value);

formContext.getControl(arg).addOption(value);

Please refer to below articles for more information.

neilparkhurst.com/.../

www.crmcrate.com/.../