Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

When does a user (from office 365 with "Power App per User Plan" Licence) becomes available in the systemuser table (from Dataverse)

Hello all,


I need some experts about the "apparition" of the users in the Dataverse 😉


My customer want to create a Canvas App to handle their Project calatog.

So, the canvas app used the dataverse to store all the data needed. No problem about that.


But one field will be used to store the Project Manager which will be an user of the table systemuser. These Project Managers need to have access to this app so they will have a Licence "Power App per User Plan".

But, I'm not sure if these persons will be available in the table User (systemuser) :

- as soon as they have a Licence "Power App per User Plan" assigned to them ?

- as soon as we share the canvas app with them ?

- as soon as they have accessed to the canvas app one time ?

- Other ?


I tried to find some information about the availability of an user in this table following the assigned licences but I don't find any clear response.

It's important for my customer because it'll be possible for them to assign a project to someone who never logged in or who is not yet access to any apps. 


Thanks a lot for your help  🙏




Julien C.

Frequent Visitor

i have a similar question:

i created an app for my collegues in the storage team, so they have an info, who took what when.

to store the data, i created a table with lookup fields on the user table (systemuser) like it already has with the created and modified by columns.

but, a few (newly created or reactivated) users are missing in that table 😞 


i can find them in the azure ad but not in the systemuser table in the default (or another) environment.

does anyone have an idea or know how/when/if AAD syncs to the systemuser table or if/where this need to be configured?



kind regards


Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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.

Top Solution Authors
Top Kudoed Authors
Users online (1,875)