cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Populate Word document - weird value for lookup columns

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:

Bildschirmfoto 2020-12-31 um 16.43.08.png

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

Bildschirmfoto 2020-12-31 um 16.42.30.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver II
Resolver II

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.

View solution in original post

2 REPLIES 2
Resolver II
Resolver II

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.

View solution in original post

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (90,253)