Answered

Expression Lookup Syntax - Populate Word

(1) Share

Report

Posted on by ez1138

218

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?

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@ez1138
Are you using CDS connector?
Please add some screen shots of your flow.

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No