Answered

Populate a Microsoft Word template with dynamicschema and repeat contentcontrol

(0) Share

Report

Posted on by paronchi

105

I have to fill a word template with data and I use Populate a Microsoft Word template with dynamicfileschema
but a field is of type "repeating content" and instead of inserting the correct values it shows the JSON (if I don't use dynamicfileschema it works perfectly)

i have to use dynamicfileschema because the template file can change slightly and i have too many templates to manage them individually

varMyTable is an JSON Array

the results is

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@paronchi ,
Have you looked at this article?

https://www.bythedevs.com/post/how-to-populate-a-word-template-with-repeating-control

Was this reply helpful? Yes No
paronchi 105 on at

Like (0)

Report

the example uses the "Populate a Microsoft Word template" connector in the "standard" way, and this way it works for me too, but I have to (want) to use it with dynamicfileschema to avoid making a case for each template slightly different (I have 1000 to manage) and using dynamicfileschema as in the examples found, only the standard controls work and not the type "repeating content"

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
I think it's displaying it as plain text because it doesn't recognise it as JSON. Can you pass your variable into a json expression before you add it to the dynamic schema and see if that works.

json(variables('output'))

Was this reply helpful? Yes No
paronchi 105 on at

Like (0)

Report

thank's, i tried but it doesn't work 😭

Was this reply helpful? Yes No
Verified answer

paronchi 105 on at

Like (2)

Report

yes, yes, yes, solved, it was enough to remove the "
example
{
"355479380": "variables('myvar')",
"504866188": variables('mytable')
}

355479380 normal word control
504866188 repeat word control
'myTable' JSON Array

Was this reply helpful? Yes No
Anderrj2 25 on at

Like (0)

Report

I want to thank you for this! This JSON was messing me up so badly, it being that I had quotes when I didn't need them is silly.

It finally got it!

I'm using an ArcGIS Survey123 trigger, making a report, then adding a table of data that I pulled from another hosted feature layer to combine things into a single document.

Was this reply helpful? Yes No