Answered

multiple related dataverse tables - with conditions and variables!

(0) Share

Report

Posted on by rowan_preston

HI All

I'm an absolute beginner and struggling with a flow to automate a process in my app.

I have 4 Data verse tables. A "Header" table which creates an auto-number, and has a lookup to a "customers" table. A "Details" table which has a parent/child relationship to the header table, and also a lookup to a "products" table. So it's basically like an orders app, except in this case it's items being returned to us. I want a flow that sends an email eventually to the person responsible for processing the return, so needs to have the auto-number, the customer details, the details of the products being returned, and the type of return to be processed.

I have my trigger as a modify record in the headers table (added a field to say when "completed") - and I then need to pull in the customers, and the details of the return (can be several rows) (and so also the products table!). I also have a choices column in my details table which specifies which type of return.... I tried initializing a variable using some help from online, but although it says it succeeded it's not showing the result.

Here's what i have:

But although it says it ran successfully - this is my result... the detail lines are both listed correctly, but the "TYPE" should be a column on the end! My variable is blank!

Apologies for the long post - any advice/help greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

WillPage 2,311 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Your Compose 2 action inside Apply to each has the expression written as text instead of in the expression editor. Having said that, it's not clear what you're doing with that outside of the Apply to each.

Despite that, your flow structure needs a bit of work. If you had a value in the RA Type variable it will be a static value and appear the same for each row of the HTML table. Are you trying to expand the value of that choices column and filter the list by its value so only items with RA Type = credit are shown in the HTML table?

Was this reply helpful? Yes No
rowan_preston on at

Like (0)

Report
Copy link

Link copied!

Hi - thanks for your reply.

Yes - that's exactly what I would like to do! have just the credits show in the table and it will be emailed to one person, and if its not a credit a similar filtered table will be emailed to a different person.

Was this reply helpful? Yes No
Verified answer

WillPage 2,311 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Add a Select action after your List Rows. Put the output of the list rows into the Select and add the key value pairs for the columns you want to keep. Much like what you've done with the Create HTML Table but name the column headers (they can't be blank) and in the RA Type column add the expression item()?['rp_ratype@OData.Community.Display.V1.FormattedValue'] or find its dynamic content.

Next, go Filter array and filter the output of that Select for item()?['RA Type'] is equal to Credit assuming you named the column RA Type in the previous Select action. You can then convert the result of that to HTML but you don't need to manually select the columns any more because you already did that in the Select.

Was this reply helpful? Yes No
rowan_preston on at

Like (1)

Report
Copy link

Link copied!

Wow - I cannot thank you enough! This just made my day!!! Something I have been struggling with for DAYS and you solved it in a minute. Thank you so much!!

Was this reply helpful? Yes No