I have a CLIENTS table, a PRODUCTS table, and an INVESTMENTS table.
Clients have products; Products have investments.
I want to build a flow on the INVESTMENTS table to check for the maturity of an investment.
If an investment is close to maturity, an email alert should be sent.
In the email, I need to display certain fields from the PRODUCTS table and certain fields from the CLIENTS table.
How do I use the fields from the other two tables in the same flow?
I start off with a LIST ROWS on the investments tables, do the necessary checks etc - no problem. I just don't know how to get the related information into the same flow.
@hildasteyn
You can use List Rows actions on all 3 tables (3 different actions). Then you the data of all 3 tables in PA ready to be parsed / manipulated / used.