Microsoft lists - data input restrictions based on user permissions

Copper Contributor

Hello,
I need to create a platform using Microsoft Lists to manage tickets.
The tickets will come from multiple countries, and each user group should only be able to view tickets related to their own country (e.g., users in the UK group should only see tickets related to UK). I understand that I can achieve this using user permissions and Power Automate flows, leveraging a column with the country information.

 

The issue arises with ticket creation. Only staff from the UK should be able to create tickets with the country set to UK. I need to find a way to prevent users in specific groups from using certain values in a column when entering records.

 

I have searched for a solution but I am still in the dark.

Can you please suggest a solution?

0 Replies