Suggestions on users in CDS

(0) Share

Report

Posted on by MagnusGöransson

424

I am currently building a model-driven app for an healthcare organization.

The purpose of the app is to follow up on and keep track of mandatory training for the workers. For example all workers that are using equippment X need to attend course Y each year.

The app will be used by managers in each department, in total around 70 workers. The workers that require training is several thousand people. The workers will never open the app, only the 70 managers.

I have some questions regarding this scenario.

1) What is triggering the AAD Users to be synced to the systemuser entity? As it is now, only a few hundred users are in the systemuser entity and i really cant see why some are there but others are not.

2) What is the best way to make sure all several thousand workers are residing in the systemuser entity so that the managers can add courses and follow up on them?

3) We can setup a dataflow from basically all data sources available, but Azure AD is not present. Any one know why? Or what do I miss here?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
HI @MagnusGöransson ,

For your first question, the Users data within the Users Entity (systemuser) would be synced automatically from your Office 365 tenant.

When you add a new user within your Office 365 tenant, the new added user would be synced automatically into the Users Entity in your CDS.

For your second qurstion, please check the first reply above. The Users data within the Users Entity (systemuser) would be synced automatically from your Office 365 tenant.

For your third question, I think you have some misunderstanding on data source types supported in PowerApps. The data source types supported in PowerApps are Table data source (e.g. Excel table, SQL Table, SP List, etc) and Action data source (Office 365, Azure AD, MS Teams, etc).

Currently, within Dataflows in PowerApps, only the table data source could be used as source data source to import data into the CDS Entity. Within PowerApps app, if you want to get resource from Azure AD connector, you should execute the following formula:

AzureAD.GetGroupMembers(...)

AzureAD.GetGroup(..)

...

Best regards,

Was this reply helpful? Yes No
MagnusGöransson 424 on at

Like (0)

Report
Copy link

Link copied!

@v-xida-msft wrote:
HI @MagnusGöransson ,
For your first question, the Users data within the Users Entity (systemuser) would be synced automatically from your Office 365 tenant.
When you add a new user within your Office 365 tenant, the new added user would be synced automatically into the Users Entity in your CDS.

For your second qurstion, please check the first reply above. The Users data within the Users Entity (systemuser) would be synced automatically from your Office 365 tenant.

Hi!
Thanks for your reply!
I have spent alot of time on this today and from what I found is that they are automatically created when looking at the systemuser entitie in the Default environment. For all the other environment the users need to have at least the free CDS license under PowerApps Free or Flow Free license pack. After adding the CDS user license they showed up in the systemuser entity in all enviroments. When the license is removed the user are removed from CDS except from the default environment.
That makes sense. However, i need to find out how to extend the 10000 free licenses to something that fit our organization 🙂
Thanks alot!!
/Magnus

Was this reply helpful? Yes No