CDS in Power App asking shared users to start premium trial

[Ben_Shil]

Have built a data entry app linked to a custom CDS to store data. Upon testing it asked users to sign up to a premium trial.

Whats the minimum licensing that'd be required for the app to be used? The apps planned for company wide use being unrolled to possibly 200+ staff and a premium license for all of them isn't really practical.

We are moving into Dynamics 365 in the near future but haven't found clear information to show if CDS is included. We'll be using Dynamics 365 for Field Service & Business Central Team Member in the future.

[jlindstrom]

Dynamics 365 database is cds and d365 license’s include the premium cds connector.

anyone using an app with common data service needs a full license for power apps—this includes per app and per user Power Apps licensed users and dynamics 365 licenses (except team members)

@Ben_Shil if this answers your question please mark it a solution so other people can find it

[v-siky-msft · Accepted solution]

Hi @Ben_Shil ,

CDS is a Premium feature, so all user need a Standalone Premium PowerApps license to access the App that uses CDS.

More reference about Power Apps Standalone plans 

The SharePoint list should be more suitable for your case. since it doesn't require Standalone PowerApps license, all users only need to be assigned with PowerApps for Office365 license, then they will be able to access the app and data.

Hope this helps.

Sik 

[Ben_Shil]

Thanks @v-siky-msft  & @jlindstrom 

A share-point list had been considered at the start but most references pointed to CDS being the way to go for long term adaptability/growth and security.

The app is for logging incident/accident events and some other H&S/HR data where everyone needs to be able to log an event but only a select group should be able to access it, we're also working on a security solution to provide varied levels of read access (supervisor only sees their teams logs while management may see all logs, etc) and from what i'd read lists arn't really a great solution and can potentially be accessed if linked through an app.

With the right setup/security settings would a list be reliable enough?

Cheers

[v-siky-msft]

Hi @Ben_Shil ,

Yes, relatively speaking, the CDS security roles has a richer capability to manage Record-level privileges with multiple access levels.

And you are right, the SharePoint site can be accessed if the users get the Site URL, which is one of SharePoint's drawbacks.

Here is a community call talking about this, hope you can learn from it to create secure PowerApps with SharePoint data sources 

Hope this helps.

Sik

[jlindstrom · Accepted solution]

Agree that hr issues are something that needs more granular security than what sharepoint lists will give you

with sharepoint you cannot have users restricted to only seeing the records that they own. Sure you can obscure the other records when the user is using the app, but since you have to share the list with the users there is no way to prevent them from seeing the other users records. 

common data service makes this really easy through security roles.

cds (now called dataflex pro) is ideal for this, and since you are going to dynamics, there are entities in the common data service and dynamics that would be good for this like cases

[luuminhvuong93]

If I have Power Apps office 365, can I use Model Driven App (which only connect to CDS ? )

@v-siky-msft 

[jlindstrom]

no. Power apps mode driven apps require common data service

[luuminhvuong93]

I can still use the Model Driven app default ( CRM Hub / Sales Team Member)

Confused becasue i dont think i have premium licnese

[jlindstrom]

If you can use that you have a dynamics 365 team member license. That is the one dynamics license that does not have power apps included in it. The sales hub team member is the only model driven app team members can use