Populate Word document - weird value for lookup columns

[AndiKe]

Hello,

I have the following situation:

List A

List B

Library Z

My goal is, that if an element is created in List B, a Word document will be created, and filled with some information, in Library Z. List A has some information that List B is referring to by lookup columns. So this is the workflow:

It is pretty easy in my opinion and it works as it should. Except two of the populated columns are shown pretty weird:

After "Value" the value I want is showing, but I do not need/want the [{"@odata.type":"#Microsoft.Azure.Connectors... stuff 😀.

Does anybody know what I am doing wrong or if this can work anyhow?

Thank you very much and kind regards

Andi

[DAllen365 · Accepted solution]

Hello, it appears as though you are using the value of the full lookup column vs. just the VALUE of the lookup column.  The column itself holds more than just the value because of all its wiring to the parent list item.  We are interested in only its value.  I believe when you set the value of the Word document content placeholder from the SP lookup column, there should be an object of dynamic content for the lookup that says like "column value" along with just the column.  Use the value, and it should give you what you're looking for.

----------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[AndiKe]

Works perfectly, thank you very much and a have a great new year!