Unanswered

Company's users as a lookup in dataverse

(0) Share

Report

Posted on by r_m_w

Hi,

I want to have a model driven app that is able have a field in a table (within dataverse) that looks up the companies users. To be clear I dont just want the users that have been given a security role to the specific organisation. In my case I have 100,000+ users and all I want to do is select them as lookup. They are not going to be a user of my app and hence no licence need.

The user list can likely come from AzureAD as we sync with on prem AD or 365 users for my company.

Is there a way to do this?

Many thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

MayankP 464 on at

Like (0)

Report
Copy link

Link copied!

I guess if you create look up field in your table which points to user and then filter use look up field based on your requirement this should work...

refer following thread for this...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Lookup-filter-based-on-different-lookup-field/td-p/697484

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you want all AD users (not just the ones with Dataverse Licenses) you will need to import that data somehow. The best way to accomplish this is through a Dataflow pulling from the Graph API. Specifically, you will want the ListUsers endpoint.

Learn more about Graph API here.
Learn more about Dataflows here.

Was this reply helpful? Yes No
r_m_w 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @cc, sounds like it should work but found that MS dont recommend it in this article. https://docs.microsoft.com/en-us/power-query/connecting-to-graph

Unless I have missed something, finding it hard to find the right category for pulling in the data. Is there a known supported step by step method?

Was this reply helpful? Yes No
r_m_w 9 on at

Like (0)

Report
Copy link

Link copied!

Thanks @MayankP but this is not what I need. Its not about the lookup- its about getting the data from Azure AD into the dataverse. Thanks anyway.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @RMW,
Suggest and best practice to leverage the out-of-the-box (OOB) User table. See tip #5 https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Top-15-best-practices-when-configuring-Power-Platform-and/ba-p/850804

For new users in your organization
The high-level idea is to assign a temp license to the user, wait until it syncs into Dataverse and then unassigned the license. Point that lockup field to the User table. Those users will be automatically be created in Dataverse and then be set as inactive once the license is unassigned. You can automatically assign the license when new users get created in O365 and unassigned once they got created in Dataverse with the help Power Automate flows and group base licensing.

For existing/old users
Easiest way I find is to import them with Excel/CSV and use the import tool: https://readyxrm.blog/2018/05/21/importing-legacy-users-to-dynamics-365-online/

Hope this helps!

Was this reply helpful? Yes No