Unanswered

Word Template remove curly bracers etc.

(0) Share

Report

Posted on by phil1804

hey, I have the following problem, I wanted to get a Word template from a large Sharepoint list. First I use GetItems with a Jquery filter to sort my entries by a specific title field, then I used a corresponding number of select operators to filter the individual columns and then in my Word template I addressed the individual rows of the columns with "array(body('Select1')[1]) etc. The transfer to the template works without any problems, but the template now contains the curly brackets etc from the array entries. Since the template is relatively large, I wanted to ask if there is a way to revise the Word document afterwards and remove the curly brackets etc.? The manual way of replacing in Word is not an option. greetings

Categories:

Building flows

Screen_Forum2.PNG

Screen_Forum.PNG

I have the same question (0)

All responses (3)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report

Any chance we could see some of the raw output from your Select to see if you can change your expression to exclude the curly braces when writing to Word?

Was this reply helpful? Yes No
phil1804 2 on at

Like (0)

Report

So I managed to remove the curly braces, however in the Word document (2nd image) the other brackets "[" , "]" and the quotation marks at the outputs are still there. In the Word document the outputs of the selects are labeled with 1-4, the outputs where neither the quotes nor the braces are visible are addressed with "first" and correspond to my expectation of the output, but as soon as I address via array("....")[1] the output takes the braces again, how can I fix this ?
And first thanks for the answer!

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

Like (0)

Report
It's still difficult to see how to resolve this without seeing the raw data that you are passing into the Select actions and what expressions you are using in them to extract the data. Plus, what output you are after as an end result.

If you're just trying to extract values from an array of objects and have them as values in a single array, then you can do the following.

Example array of objects:
[ { "Color": "Red" }, { "Color": "Green" }, { "Color": "Blue" } ]

Output you are trying to achieve:
[ "Red", "Green", "Blue" ]

How to achieve this - using the following expression in the Map of the Select:
item()?['Color']

If you then wanted to join the values in the array you could use a Join as so:

This would give you:
Red,Green,Blue

Was this reply helpful? Yes No