cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diepic
Resolver II
Resolver II

retrieve data from POA table

Hi all

I need to retrieve data from principalobjectaccess (POA) table, but the dataverse connector dont recognize the name of the hide table.

diepic_0-1664352127434.png

in most post that I've read, I find that I should use the CDS connector and CDS (current environment) connector, but I'm not able to find them in my list of connector .... maybe I mistake something with translation in italian??? ....

I'm working with dataverse db on Dynamics 365 sales.
Thanks for any help or suggestion.

 

1 ACCEPTED SOLUTION

Accepted Solutions
diepic
Resolver II
Resolver II

Hi @Jondoesflow 

many thanx for your  reply.
I've solved in this way ...... 

....

Attached the steps to obtain the users from table POA (hoping that can be usefull)

diepic_1-1664633852399.png

 

diepic_2-1664633861068.png

 

diepic_3-1664633868740.png

 

diepic_4-1664633878398.png

 

diepic_5-1664633890733.png

 

 

 

View solution in original post

6 REPLIES 6
Jondoesflow
Helper V
Helper V

Does this work for the custom table value?

 

principalobjectaccessset

diepic
Resolver II
Resolver II

Thank you for reply @Jondoesflow 

I've read in a 2nd time how to find the "EntitySetName" with XrmToolBox  (https://www.itaintboring.com/dynamics-crm/how-to-verify-principle-object-access-directly-from-the-fl...) ... 

diepic_0-1664369644450.png

but for "get a row by ID" seem not working... today I try with "list rows".
If you have any idea or suggestion or link to learn, I'll be grateful.

 

Does the account you are using to get the rows, have the right permissions to this table?

Hi @Jondoesflow 

thanks for reply.

I've the right permission, I'm administrator in this database

Ok, just to be double sure, have you checked that the security role you have in this environment has read and write permissions to this table?

 

Can you provide a screenshot ?

diepic
Resolver II
Resolver II

Hi @Jondoesflow 

many thanx for your  reply.
I've solved in this way ...... 

....

Attached the steps to obtain the users from table POA (hoping that can be usefull)

diepic_1-1664633852399.png

 

diepic_2-1664633861068.png

 

diepic_3-1664633868740.png

 

diepic_4-1664633878398.png

 

diepic_5-1664633890733.png

 

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,977)