Filter microsoft entra id table using query contains(@email address)

Like (0) Share

Report

Posted on 30 Jan 2024 13:41:09 by Vani_Mankad_BS

Hi,

I have a requirement to get all the organisation users. I am trying to use microsoft entra id under list rows component in dataverse and filter by contains(@Companyemailaddress). I get an error. Please suggest'.

We are using license free version of power apps to evaluate platform. Do i need specific license in order to use microsoft entra id ?

Categories:

Microsoft Dataverse

All responses (4)

Answers (0)

Steve27 11 on 08 Apr 2024 at 17:27:20

Like (0)

Report

Re: Filter microsoft entra id table using query contains(@email address)

Can that work with the Entra ID table"? GET does not seem to be a function that PowerApps understands.

Is it possible to Filter() the email address domain of the Entra ID table?
Shashank Bhide 934 Super User 2025 Season 1 on 08 Apr 2024 at 17:18:36

Like (0)

Report

Re: Filter microsoft entra id table using query contains(@email address)

Why not try graph API endpoints with simple HTTP requests

https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http
Community Power Pla... on 08 Apr 2024 at 17:11:42

Like (0)

Report

Re: Filter microsoft entra id table using query contains(@email address)

I have this same problem using Dataverse for Teams. Did you find a solution?

Filter() works but it only searches text of the email address before "@"
ivan_apps 2,187 Super User 2025 Season 1 on 30 Jan 2024 at 15:45:34

Like (0)

Report

Re: Filter microsoft entra id table using query contains(@email address)

Can you share a screenshot? are you using the entra connector to retrieve user details? Perhaps use the Office365Users connector instead?