Hi, the PK for my "company" table is Company_ID. In that same table I have Company_Name. For another table I'm using that's primarily filling my Word document is called "audit". I have Company_ID in that table with a relationship with the "company" table.
What expression can I use to pull the Company_Name from the "company" table?
Solved! Go to Solution.
Hi @ez1138 ,
You could refer to screenshot below to create the flow:
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don’t believe so. My connections are “get rows (v2) for SQL server.
Hi @ez1138 ,
You could refer to screenshot below to create the flow:
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply. I believe I added everything in although the last step for compose is asking for a variable of some sort. Does an initiate or something need to be added before?
Hi @ez1138 ,
Your flow in wrong for you have Apply to each added one more.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for the reply. I removed the extra "apple to each". For the "compose", would I need an "initiate" called "Company_Name"?
Hi @ez1138 ,
You could create the variable outside the Apply to each.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.