Populate word document with encodian using multi select checkboxes

(0) Share

Report

Posted on by AdamHewitt

I am using encodian to populate word documents (i am in the free tier).

Everything works fine for single select and text boxes but my issue comes about when i have multiselect check boxes.

When i get results in power automate, it creates an array of all of the selected options. The issue is the array doesnt look how encodian wants it.

This is my json for encodian:

{
"EVENTNAME": "",
"NOWDATE": "",
"CLIENTNAME": "",
"SUBPROCESSOR1": "",
"PROCESSING1": "",
"COLLECTEDDATA": "",
"EXAMPLE": ""
}

and this is what is populated

{
"EVENTNAME": "TEXT",
"NOWDATE": "17 July 2023",
"CLIENTNAME": "TEXT",
"SUBPROCESSOR1": "Test Name Of Subby",
"PROCESSING1": "This is some info.",
"COLLECTEDDATA": "[
"Data 1",
"Data 2",
"Data 3"
]",
"EXAMPLE": "TEST"
}

encodian want it to look like this

{
 "companyName":"Encodian", 
 "bullets": [
 {
 "listFirstName": "Efren",
 "listLastName": "Gaskill"
 },
 {
 "listFirstName": "Sanly",
 "listLastName": "Keyme"
 },
 {
 "listFirstName": "Mark",
 "listLastName": "Nigma"
 }
 ]
}

This has key/value pairs.

How could i go about getting this from forms?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

AlexEncodian 4,409 Moderator on at

Like (0)

Report

Re: Populate word document with encodian using multi select checkboxes

@AdamHewitt

Happy to help. I don't think I fully follow your requirements however. Is this a Microsoft Form? And where is the data between the first and second array you posted coming from as a check box is simply a yes/no type answer? Also, the first array does not look like a check box answer (it has empty values).

Was this reply helpful? Yes No
AdamHewitt 55 on at

Like (0)

Report

Re: Populate word document with encodian using multi select checkboxes

Yes this is an MS form.

The first bit of JSON is how I am populating the word doc.

This

{
"EVENTNAME": "TEXT",
"NOWDATE": "17 July 2023",
"CLIENTNAME": "TEXT",
"SUBPROCESSOR1": "Test Name Of Subby",
"PROCESSING1": "This is some info.",
"COLLECTEDDATA": "[
"Data 1",
"Data 2",
"Data 3"
]",
"EXAMPLE": "TEST"
}

Is what encoding is seeing coming in when I look at the raw inputs.

The data is coming in from the form, where I have a list of options in one questions where the user can tick as many as they need to.

Ultimately I will be turning this into a bulleted list which is why I have included the JSON that encoding expect - based on info from their website.

Was this reply helpful? Yes No
AdamHewitt 55 on at

Like (0)

Report

Re: Populate word document with encodian using multi select checkboxes

I have attached the power automate flow hoping that will provide more clarity

Was this reply helpful? Yes No