Unanswered

How to filter rows with lookup column in Dataverse

(0) Share

Report

Posted on by Community Power Pla...

Hello Community,

I have been trying to figure out how to set the filter query in the List Rows action in Dataverse, to only get the related records from the same parent lookup. As an example, for each Account, we have multiple child Contacts associated with the same parent account record (i.e. having the account as the lookup on the contact).

In the Power Automate flow, I use the List Rows action to first get all the accounts in Dataverse, and then use "Apply to each" operation to loop through each account. For each loop, I want to use the List Rows action to get all the related contact records associated with the same account via the account lookup. How can I define that filter query so that the List Rows action in each loop returns only the list of related contacts for the same account lookup, as we loop through each account?

Any insights would be greatly appreciated!

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

{ColumnName} eq '{YourDynamicData}'

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @StretchFredrik ,

Thanks for your reply. I tried the following, however it's not working. It gives me the following error:

Did I miss anything in terms of syntax?

Was this reply helpful? Yes No
StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (1)

Report

The column doest exist, are you taking the "backend" name of the column? I usually get this by looking at the API call and seeing what the internal name for the field is.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @StretchFredrik ,

Yes, in this case, in the filter condition, I am putting parentcustomerid eq 'Account' (Account being the Dynamic Data). The field "parentcustomerid" is the out of the box internal name of the lookup field to Account on the Contact entity. Not sure why it's complaining the field doesn't exist because it's definitely there...

Was this reply helpful? Yes No
Verified answer

Rose2022 15 on at

Like (4)

Report

You should use _parentcustomerid_value which holds a numerical value of the accountid. Hope it works!

Was this reply helpful? Yes No
CRMMaven 2 on at

Like (0)

Report

Can I use month day and year functions if the filter condition for the date field
example
new_certificationanniversarydate ne null and month(new_certificationanniversarydate) eq @{utcNow('MM')} and day(new_certificationanniversarydate) eq @{utcNow('dd')} and year(new_certificationanniversarydate) ge @{utcNow('yyyy')}

When using this function flow try to execute the step multiple times and every time it returns a status "notimplemeted"
can you suggest alternate way to get this done.

Was this reply helpful? Yes No
Winsderl 7 on at

Like (0)

Report

Thanks @Rose2022 , this solution definately works for me.

Was this reply helpful? Yes No