Answered

Calling properties from Azure Active Directory to filter a Gallery

(0) Share

Report

Posted on by ddl3

Hello Community!

I need your help, please 🙂

I have a gallery in PowerApps to show active users from the active directory. I have the function that returns all active users, but I need to exclude those who have the property Employee ID <> "Contractor." The formula needs to be fixed. Does anyone have an idea about it?

This is the formula:

Filter(Office365Users.DirectReportsV2(User().Email).value, accountEnabled && ('Employee Id' <> "Contractor"))

Here are the screen shoots:

From the Active directory

Thank you so much,

Danie

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ddl3 ,

Please call the api to create a collection.

ClearCollect(Col,Filter(ForAll(Filter(Office365Users.DirectReportsV2(User().Email).value,accountEnabled),With({temp:Office365Users.HttpRequest("https://graph.microsoft.com/v1.0/users/"&id&"?$select=employeeId,displayName,userPrincipalName,id","GET","")},{id:Text(temp.id),employeeId:Text(temp.employeeId),displayName:Text(temp.displayName),userPrincipalName:Text(temp.userPrincipalName)})),employeeId<>"Contractor"))

Best Regards,

Wearsky

Was this reply helpful? Yes No
ddl3 23 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response. Sadly, when I call the Graph explorer it doesn't return the field employeeId.

Was this reply helpful? Yes No