Skip to main content
Community site session details

Community site session details

Session Id : NeeUXhQZIbuF5uE5jiIgcR
Power Automate - Using Connectors
Unanswered

Virtual Tables in Dataverse error

Like (1) ShareShare
ReportReport
Posted on 12 Jan 2023 06:33:23 by 167

Hi All,

 

I currently have a Power Portal that's connected to a Dynamics Finance and Operations through virtual tables. I'm able to do CRUD operations on the UI side, however I am getting errors when attempting to add a hook through Power Automate. All my power automate flows work fine on native tables in the Dataverse. It's saying it is some sort of permissions problem but I think I've given the current connection enough permission seeing as the CRUD operations on the Power Portals work fine for the same user. I also don't know which permissions it is referring to.

 

 

gospa_0-1673505061256.png

 

 

RetrieveMultipleRequest failed with error:
Principal user (Id=8c85e141-1159-ed11-9562-000d3af46a00, type=8, roleCount=1, privilegeCount=18, accessMode=4), is missing prvReadSolution privilege (Id=b64e92c8-5d2a-4052-a026-1b73eff9cebf) on OTC=7100 for entity 'solution' (LocalizedName='Solution'). context.Caller=8c85e141-1159-ed11-9562-000d3af46a00. Or identityUser.SystemUserId=8e3c16c3-9f8a-497f-9ebe-07866b37c65b, identityUser.Privileges.Count=4211, identityUser.Roles.Count=0 is missing prvReadSolution privilege (Id=b64e92c8-5d2a-4052-a026-1b73eff9cebf) on OTC=7100 for entity 'solution' (LocalizedName='Solution').

  • Community Power Platform Member Profile Picture
    on 27 Jan 2023 at 11:01:55
    Re: Virtual Tables in Dataverse error

    Im having the same problem. I can add records but i cant create a trigger. Did you find a solution?

  • gng Profile Picture
    167 on 12 Jan 2023 at 17:04:51
    Re: Virtual Tables in Dataverse error

    Moving topic to general discussion as it is more of a general issue possibly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Loading complete