web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

how show all users

(0) ShareShare
ReportReport
Posted on by 86

Hi,

 

today i connect my admin account in power app and i need to create list of records our HW and users (in fact i need to create list of PCs and need list of all users in our organization and assign PCs to users) - all works fine (i create list of PCs and assign to users) but there is an big problem, we have about 200 people in org and there is in power apps only 81 shows so i cant assig all my PCs to users. So my question is is anyone known where may be a problem? Why there is no all my users (we have E3 and F3 licences but there is no problem).

I attach here a picture

 

So if anyone known that i will be very gratfull. Thanks

I have the same question (0)
  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @pedacokorilo,

    By the picture I assume you have a CDS environment. Only the users that have a license assigned with automatically be created in CDS. Also if your CDS environment is linked to a security group then only the users that have a license and are members of the group will be created in the environment. Double check that all your users have a proper licensed assigned in O365 which is most likely your issue.

    Note to access CDS, these users required a Power Apps per user, per app licenses or Dynamics 365 type of licenses.

    Cheers

  • David Jennaway Profile Picture
    716 on at

    To add to the previous response, you will only have licensed CDS users (and optionally those linked to a security group) within the CDS environment. If you need to assign PCs to users who do not have a CDS license, you have 2 main options:

    • Use the contact entity in CDS, rather than the user entity, and assign PCs to contacts. If you use the contact entity for contacts who are not users, you could add a field to distinguish these
    • You can temporarily assign a CDS license to a user, which will cause the user to be created in CDS. Then you can remove the license, and the user record will remain in CDS. Therefore, if you temporarily assign a CDS license to each user, you will end up with all users in CDS

    Unfortunately both of these approaches will need some manual intervention when new users are created in Office 365

  • pedacokorilo Profile Picture
    86 on at

    Hi @DavidJennaway  and @EricRegnier 

     

    Thanks for answer but all our users have O365 licences (E3 of F3)

     

    And there is no connect which are show or not in power apps (there are some with E3 and some with F3) also some of them have PBI or another licence but thats does not matter. In attach i send just for example two users and one of the is shown in PA and the second one doesnt.

     

    We doesnt use any security group for CDS.

     

    And can you ask also where i can see who have or not CDS licence, all we have is E3 or F3 office 365 licence.

     

    Thanks

  • pedacokorilo Profile Picture
    86 on at

    just one more reply to you @DavidJennaway 

     

    In attach you can see that our users have licences and for example that user i send a picture he doesnt shown in PA

  • pedacokorilo Profile Picture
    86 on at

    Sorry for smap @DavidJennaway but you write something about security group and i checked in our setting of organization in PA admin and there is no group selected, also there is a sign Cannot be assigned to this environment. And if i click on question mark here there is a  sign
    security groups cannot be assigned to default and development environments (via attachment but sorry my PA admin is in czech language but i already translate the text)

     

    So maybe is there a problem but anyway why it show some users ?

     

    Thanks for help

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @pedacokorilo,

    Do you resolve this? You license type is probably the issue then. It's my understanding that an E5/E3/E1 or F3 license cannot use CDS and model-driven apps, that requires a specific Power Apps license type.

    So why do you have users in CDS in the first place? Not sure, Was CDS created in the Default environment? Maybe that could be the reason or maybe they had a license before which got removed?

    For more info on licensing, please refer to the license guide: https://docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus

     

    Here's a similar post from another user: https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-and-Common-data-services-licensing/m-p/504657 

    Cheers

  • pedacokorilo Profile Picture
    86 on at

    Hi @EricRegnier 

     

    I didnt resolved yet, but i contacted MS support so i m waiting now for them. Bud if is there a problem with E3 or F3 licenced, why it show me over 80 users  - if there no one so it could be licenced problem but in this case it is weird really.

  • v-siky-msft Profile Picture
    on at

    Hi @pedacokorilo ,

     

    From this article, we can know that all users in the organization are added automatically to the environment when an environment is created with a Common Data Service database or a Common Data Service database is added to an existing environment, Unless a security group is selected as an access filter.

     

    If you want to add users to an environment that has a Common Data Service database, please Go to Settings > Users + permissions > Users to Add Users one by one.

     

    To add users in bulk, try to associate the security group containing all licensed users with the environment, then all licensed user are added to the Common Data Service environment. For more information: https://docs.microsoft.com/en-us/power-platform/admin/control-user-access 

     

    Hope this helps.

    Sik

  • pedacokorilo Profile Picture
    86 on at

    Hi @v-siky-msft 

     

    thanks for answer but i can add user manually but i need to automaticaly add all our users in our company bcs i this case it will be double work to add new user in O365 admin and after that add them manually in power apps, so i wait for MS support to call me today (i hope) and we check it together with them. If we done i post it here where is a problem.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard