So I'm building my first app and using dataverse as the main source. I have two columns in the dataverse table to refer to Entra ID, but instead of showing the entire users list, I would like it to only show based on particular job titles or departments.
Items Poperty = Choices([@'Permit Management'].cr442_PermitTechSearch)
The column type is Lookup, the table is called Permit Management, and schema name is cr442_PermitTechSearch
For one datacard I'm wanting to only see people with the job title of Permit Tech (Permits) and the other Project Manager (Project Managers)
Is this possible using Filter? or would I need to make a new reference table with a new column in my table?