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

Parse JSON result into Word template

Hi, 

 

I am trying to set an Object from PARSE JSON as a value for a word template however this is not working - from what I can tell this is because the object is not in plain text format. 

 

Is there a way to get around this without using 3rd party apps? the PARSE JSON is coming from an SQL Standard Procedure so if there is something I can do on the SQL side to fix this I am willing for any suggestions, Thank you!

2 REPLIES 2
Highlighted
Super User III
Super User III

hi @HWBAB  please could you provide us an screanshot?



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted

Hi @ChristianAbata Thanks for the reply - screenshot below of the overall flow 

 

HWBAB_0-1600953104543.png

HWBAB_1-1600953142185.png

Info Being Parsed from the SQL Stored Procedure into Objects

HWBAB_2-1600953209761.png

 

Setting the PIN on the Word template to the JSON Object CustomerIDTEXT

 

HWBAB_3-1600953256005.png

This is the value that the Template Returns after trying to fill using the CustomerIDTEXT

 

Hope these screenshots help, thanks! 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (10,765)