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