cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carl1to
Helper II
Helper II

Lookup to all users of Organisation (Dataverse / model driven)

Hi all,

 

I'm developing a model driven app that needs a lookup field to all users that are present in my organisation. In canvas-apps this would be achieved with the O365 connector.

 

First approach was to lookup to the Out-Of-Box User table. But in this table, only the users that have access to the environment are listed. Is it correct that I need to update the User table or another custom Contact table with the data in Azure AD by using a cloud flow? (Solved: Missing users in Dataverse - Power Platform Community (microsoft.com))

 

I can't really believe that there is none Out-Of-Box solution for this?

 

I found this approach: Force Sync users from Azure AD to Dataverse environments – Power Automate – Power Platform Learning ... But I'm not sure where it would populate the 

1 ACCEPTED SOLUTION

Accepted Solutions
rampprakash
Super User
Super User

Hello @carl1to,

 

As per Data Verse, we can access the users only if they have proper License. If not, Create another Customer Table and create fields based on your requirement and use it. There is no other way.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

View solution in original post

3 REPLIES 3
rampprakash
Super User
Super User

Hello @carl1to,

 

All the Users available in security Group's having a Proper License?

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

carl1to
Helper II
Helper II

@rampprakash 

Thank you for you question.

No, not all users in the Organisation have a license for Dataverse. But nevertheless I would like to access all users from a lookup in this app.

rampprakash
Super User
Super User

Hello @carl1to,

 

As per Data Verse, we can access the users only if they have proper License. If not, Create another Customer Table and create fields based on your requirement and use it. There is no other way.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,380)