Dataverse List rows - nested query

(0) Share

Report

Posted on by brknsclstv

Hi,

I'm not sure how best to start with this.

I have a requirement to produce a CSV that lists a number of rows from a table (simple enough), but I also need to include a string value which is concatenated from one or many records that are related 1-Many to the parent record.

A good example of this would be concatenating all contact names to a single field and producing a CSV of account names with 1 line per account.

I can get both data points, where I'm struggling is bringing the data together. I'm sure there must be a simple way of doing this?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @brknsclstv

If you're getting the results from a list rows with a filter query, you could then use a select action in text mode (click the T to enter the mode) and this would create an array of the dynamic value. You can then run join() on the array with the character of your choice to create a string of results.

Hope that makes sense?!

Damien

Was this reply helpful? Yes No
brknsclstv 3 on at

Like (0)

Report

Hi @DamoBird365

Thanks for your response. Not sure I follow though.

Yeah, I'm using two list rows - 1 for accounts and 1 for contacts filtered by parentaccount id from the first list row.

Are you suggesting that I add the select action into the each loop for the contact list rows. How would I join that back to the account row so I can see 1 account per row (with contact names concat) in the CSV?

Was this reply helpful? Yes No