You’re offline. This is a read only version of the page.
4
I want to build a model driven app using Dataverse tables, which are considered complex tables
- contact
- account
- lead
- opportunities
Users have Microsoft Business Standard + Power App per App License. Is this sufficient?
Is it allowed to use Server-Side sync features configured in environment settings?
I wonder because the tables come with a certain intelligence, for example qualifying leads....
try to create a new Power Apps environment without installing Dynamics 365 apps, do you see the Opportunity table? afaik you don't get that table as it comes with the 365 Sales applications.
the "complex" scenarios you mention is when you have a mix of licenses with an environment where the Dynamics 365 apps are installed.
Licensing is a tricky argument, because something you write today may not be valid tomorrow.
To my knowledge (and I repeat to my knowledge) an operation like qualifying a lead to an opportunity triggers MS logic intended for the Dynamics 365 apps, so the user performing it will require to have a Dynamics 365 license.
Let's say for example (and I repeat for example) that reading opportunity records is inside the bounds of the Power Apps license but creating not, a user with just Power Apps can read but cannot create new records and your security roles should reflect this. (I repeat again, this is an example, not backing a real scenario with my words, it may be true or not as today)
some excerpts from: License requirements for tables - Power Apps | Microsoft Learn
To know whether or not you added complex business logic to your tables, review the list of plug-in assemblies and workflows configured in your environment. For the list of tables which may contain server side logic after installing a Dynamics 365 app (such as Dynamics 365 Sales or Dynamics 365 Customer Service), see Complex tables requiring Power Apps or Power Automate licenses
....
tables that are tied to the functionality of Dynamics 365 apps (such as Dynamics 365 Sales or Dynamics 365 Customer Service) require app users to have the corresponding license for that application if they want to create, update, or delete rows within the tables. For a full list of restricted tables, see Restricted tables requiring Dynamics 365 licenses.
Are you sure? I cannot find official source stating this. Sure I'm not allowed to use restricted tables, but complex tables? Both Contact and Opportunity are complex tables and not restricted tables.
contact and account comes with the Power Apps, but Opportunity requires a Dynamics 365 license
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
