Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

List Rows action in Dataverse

(0) ShareShare
ReportReport
Posted on by 2
I have a subgrid called payment installment details, in my opportunity entity form. it has a lookup field to the opportunity entity. I now want to grab the rows in this subgrid in power automate to populate a table in a word template. The subgrid has 3 other fields, called description, due date and amount. I want to grab the rows in that subgrid that are peculiar to that particular opportunity record. 

i am having issues with the filter rows part of the list rows action and the screenshot is attached below.
  • Suggested answer
    Tom_Gioielli Profile Picture
    1,847 on at
    List Rows action in Dataverse
    I also will typically do the filter for the GUID of the parent record specifically, which might also help (in addition to the underscore that Jonas mentioned).
     
    _cr133_relopportunity_value eq 'GUID'
     
     
  • Verified answer
    Jonas "Jones" Melgaard Profile Picture
    4,601 Super User 2025 Season 1 on at
    List Rows action in Dataverse
    You need to put a "_" sign in front of the logical column field name.

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

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Adis Profile Picture

Adis 136 Super User 2025 Season 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 81

#3
Jonas "Jones" Melgaard Profile Picture

Jonas "Jones" Melgaard 77 Super User 2025 Season 1

Product updates

Dynamics 365 release plans