Filter an Entra ID column by Job Title or Department

(1) Share

Report

Posted on by marshallzart

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?

All responses (1)

Answers (1)

Verified answer

Ami K 15,665 Super User 2024 Season 1 on at

Like (1)

Report
Re: Filter an Entra ID column by Job Title or Department

@marshallzart - couple of examples below:

Filter( Choices([@'Permit Management'].cr442_PermitTechSearch), 'Job Title' = "Permit Tech (Permits)" || 'Job Title' = "Project Manager (Project Managers)" )

Filter( Choices([@'Permit Management'].cr442_PermitTechSearch), 'Job Title' in [ "Permit Tech (Permits)", "Project Manager (Project Managers)" ] )