Forum Discussion
rsderby
Mar 03, 2023Copper Contributor
Using Power Automate and Syntex to create document with multiple tables HELP?
I work for a performing arts organization, and we manually create documents ("one sheets") related to performance information in tables like casts, crews, chorus details, etc. See the example pictur...
Mario_Fulan
Sep 18, 2023Iron Contributor
Steve Pucelik - I see one big difference between your working sample and my failed attempt. In your sample your json is in this format {"Correspondence Name":"Value1", "Date Sent":"Value2"} but the output from the data select action for my sample has the value first and the field name second like this by comparison {"Value1":Correspondence Name", "Value2":"Date Sent"}. Seems the data select is backwards in my case. I'll try this and respond back.
Mario_Fulan
Sep 18, 2023Iron Contributor
Success. It now works for me. What an idiot I am. I know the JSON format but for some reason had dyslexic response. This is now working for me. Thanks everyone.
- Wayne_AddisonOct 04, 2023Copper ContributorSuccess for me too! My problem... I didn't put labels in the header row of the table, that was my 'Microsoft Word, Sorry, we ran into a problem' error AND when I did put labels I didnt make the JSON field names exactly match the labels. I think I'm the winner Mario.
Thanks to all on the thread.