Forum Discussion
No Restricted tables in Dynamics Sales ? and Question for Portal users
Hello,
I don't have full answer in the artice https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-restricted-entities .
1. I need to clarify if a Power Apps Premium licensed user can create, edit and close opportunities.
-> Sales tables (Lead,Opportunity, Quote...) are not listed
2. Also would it be possible for a Power Pages Authenticated (internal User) to close a case.
-> It says about "Power Apps, Power Automate, or Copilot Studio licensed" but Power Page is not listed.
Any help is welcomed :)
Kind regards,
Pierre-Olivier
I have a response from the team:
1. Yes, a Power Apps Premium licensed user can create, edit, and close opportunities, provided that the operations are performed on non-restricted tables
2. No. Closing a case involves operations on the 'Case' (incident) table, which is classified as a restricted table.
4 Replies
- JillArmourMicrosoft
Community Manager
Thank you MartijnElfers! Also tagging a new superuser RobertHemsley in case he has anything to add. :)
- MartijnElfersBronze Contributor
I've seen this question also drop by on LinkedIn 🙃
Regarding point 1, if it is not a restricted table, I do not see why not. Sometime ago Microsoft wanted to make some changes regarding additional limitations on actions, but as far as I can see this is not in place. Thus a Power Apps user should be able to access those tables and do everything, as long as they're not restricted tables.
For point 2, I believe you should license internal users also with Power Apps or an or the applicable D365 licenses to access Power Pages. So not with Power Pages Authenticated license pack (which is for external users), but also Power Apps Premium. And those licenses of course have access to Dataverse/D365 unrestricted tables as stated in point 1.
- JillArmourMicrosoft
Community Manager
Hello Popujol I have forwarded this to the team for a response. Stay tuned!
- JillArmourMicrosoft
Community Manager
I have a response from the team:
1. Yes, a Power Apps Premium licensed user can create, edit, and close opportunities, provided that the operations are performed on non-restricted tables
2. No. Closing a case involves operations on the 'Case' (incident) table, which is classified as a restricted table.