
Announcements
I have a custom Table (Table A) in Dataverse where a Security Role is set .
Record Ownership is 'User or team' + Read permission is set at User level.
When I load this table in to a Gallery using the Power App I am able to see the records specific to the user.
Eg :-
User A
| Record1 |
| Record 2 |
| Record 3 |
User B
| Record1 |
But then I try the List Rows Action of this table (Table A) in PowerAutomate , It returns the rows of the user with which the flow was created (and not the Run only user) even though the flow was triggered on a Button click from an App.
I am using a Fetch Xml Query in the List Rows Action as well
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="xx">
<attribute name="xx" />
<attribute name="ownerid" />
<attribute name="owningbusinessunit" />
<filter type="and">
<condition attribute="ownerid" operator="eq-useroruserteams" />
</filter>
</entity>
</fetch>
Any ideas or suggestions appreciated.
Hi @JAJ13JAK ,
Please try to set 'run only users' to 'Provided by run only user'.
Best Regards,
Wearsky