Expression Lookup Syntax - Populate Word

[ez1138]

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?

[Mira_Ghaly]

@ez1138 

Are you using CDS connector?

Please add some screen shots of your flow.

[ez1138]

I don’t believe so.  My connections are “get rows (v2) for SQL server.

[v-alzhan-msft · Accepted 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.

[ez1138]

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?

[v-alzhan-msft]

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.

[ez1138]

Hi, thanks for the reply.  I removed the extra "apple to each".  For the "compose", would I need an "initiate" called "Company_Name"?

[v-alzhan-msft]

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.