List Rows action in Dataverse

(0) Share

Report

Posted on by Community member

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.

Categories:

Dynamics 365 general

Power Platform integration

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (0)

Report

You need to put a "_" sign in front of the logical column field name.

I found this article that explains it a bit more: https://softchief.com/2023/05/30/filter-record-using-lookup-field-power-automate-dataverse/

Was this reply helpful? Yes No
Suggested answer

Tom_Gioielli 2,795 Super User 2025 Season 2 on at

Like (0)

Report
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'

Was this reply helpful? Yes No