Power Pages - Form lookup field with Entra ID

(0) Share

Report

Posted on by nhtkid

188

Dear Community,

I am building a website based on a Dataverse table.

To be able to look up in the form, I believe I need to have a lookup column in the table.

I need to look up AAD user so I am relying on the Microsoft Entra ID table.

But I know this table is special, for example, it is not possible for me to create a permission so anonymous user can look it up when filling up the form.

So I am thinking to create a custom table that copies the Entra ID table, the data can be updated by a scheduled flow.

Then in the table lookup column, I can select the related lookup table to this new custom table.

Is this the correct approach?

Below is the error if I try to look up Microsoft Entra ID table directly, even with the permission.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Lucas001 2,429 Super User 2025 Season 2 on at

Like (1)

Report

Hi @nhtkid,

I think you refer to the AAD User table: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/aaduser-entity
If you want users to get direct data the anonymous role needs to get access to Microsoft Graph at the table is just a virtual one. How exactly we can achieve that in Power Pages, I am not sure.
Your approach would be a solution which in the end will work. I would suggest going with your approach and later on see if you can get people access to the table.

--------------------------------------------------------------------------------------

Hope that helps.

If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.

Was this reply helpful? Yes No
Verified answer

nhtkid 188 on at

Like (0)

Report

Thank you @Lucas001 for the guidence!
In the end, I went with the system user table instead.
Solved: Re: How to filter the Sytemuser table - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No