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

All responses (3)

Answers (0)

Sort by

AlexEncodian 4,409 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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).
AdamHewitt 55 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
AdamHewitt 55 on at

Like
a
(0)

Report
Copy link

Link copied!

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