web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / List Rows Action Not R...
Power Apps
Unanswered

List Rows Action Not Returning Records based on the current user.

(0) ShareShare
ReportReport
Posted on by 17

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.

JAJ13JAK_1-1718567238354.png

 

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.

 

 

 

I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    Hi @JAJ13JAK ,

     

    Please try to set 'run only users' to 'Provided by run only user'.

    vxiaochenmsft_0-1718587553252.png

    vxiaochenmsft_1-1718587583015.png

     

    Best Regards,

    Wearsky

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard