cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User II
Super User II

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

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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!

Top Solution Authors
Users online (8,073)