Forms Response to Email - Email formatting help

[Feathergun]

I have a built a flow that takes a rather lengthy quality control check list and formats responses into an email that it submits to team members that need that info back from the field. I have several multiple answer questions in the form and when I call the dynamic data into my email body, it shows in the email like this:

["GROUT LINES FOR EACH AREA ARE STRAIGHT, HAVE CONSISTENT WIDTH ACROSS EACH AREA OF INSTALL (IF APPLICABLE), ARE NOT OVER OR UNDER FILLED, HAVE CORRECT AND CONSISTENT COLORATION THROUGHOUT, AND ARE FREE OF VOIDS/PINHOLES/CRACKS/ETC. ","COLOR MATCH GROUT CAULKING OR EQUIVALENT HAS BEEN USED AT ALL CHANGES OF PLANE THROUGHOUT TILED AREAS","TILE INSTALLED IN EACH AREA IS THE CORRECT TILE AND HAS CONSISTENT/CORRECT PATTERN PER OUR NOTES, IS FREE OF EXCESSIVE LIPPAGE, CRACKS, CHIPS, SCRATCHES OR OTHER DEFECTS/DAMAGE, IS WELL BONDED AND FREE OF HOLLOW SOUNDING SPOTS OR MOVEMENT, HAS EVEN SPACING OF COLOR VARIATIONS OR VEINING SUCH THAT DUPLICATE TILES ARE NOT INSTALLED TOO CLOSELY TO EACHOTHER.","WHERE APPLICABLE, TILE THAT REQUIRES SEALING IS SEALED"]

How do I split up the answers so they show on separate lines. I ready through some other posts with a similar question but their flows differ from mine and I am a total novice at this and it took a lot of work just to get this one working original. Here is my current flow

Here is an example of one of the questions where this occurs:

The end of my form has a field where users are requested to submit up to 10mb of photos relevant to the inspection they completed onsite. Wanted to throw that out there so you might better understand the later parts of the flow. Help is appreciated, thank you!

[ManishSolanki]

Hi @Feathergun 

Pls share the sample of expected output from the input array:

["GROUT LINES FOR EACH AREA ARE STRAIGHT, HAVE CONSISTENT WIDTH ACROSS EACH AREA OF INSTALL (IF APPLICABLE), ARE NOT OVER OR UNDER FILLED, HAVE CORRECT AND CONSISTENT COLORATION THROUGHOUT, AND ARE FREE OF VOIDS/PINHOLES/CRACKS/ETC. ","COLOR MATCH GROUT CAULKING OR EQUIVALENT HAS BEEN USED AT ALL CHANGES OF PLANE THROUGHOUT TILED AREAS","TILE INSTALLED IN EACH AREA IS THE CORRECT TILE AND HAS CONSISTENT/CORRECT PATTERN PER OUR NOTES, IS FREE OF EXCESSIVE LIPPAGE, CRACKS, CHIPS, SCRATCHES OR OTHER DEFECTS/DAMAGE, IS WELL BONDED AND FREE OF HOLLOW SOUNDING SPOTS OR MOVEMENT, HAS EVEN SPACING OF COLOR VARIATIONS OR VEINING SUCH THAT DUPLICATE TILES ARE NOT INSTALLED TOO CLOSELY TO EACHOTHER.","WHERE APPLICABLE, TILE THAT REQUIRES SEALING IS SEALED"]

Also, show the email body set in "send an email" action in edit mode.

[Feathergun]

This is how I'd like the output to read in the body of the email that gets sent:

• GROUT LINES FOR EACH AREA ARE STRAIGHT, HAVE CONSISTENT WIDTH ACROSS EACH AREA OF INSTALL (IF APPLICABLE), ARE NOT OVER OR UNDER FILLED, HAVE CORRECT AND CONSISTENT COLORATION THROUGHOUT, AND ARE FREE OF VOIDS/PINHOLES/CRACKS/ETC.
• COLOR MATCH GROUT CAULKING OR EQUIVALENT HAS BEEN USED AT ALL CHANGES OF PLANE THROUGHOUT TILED AREAS
• TILE INSTALLED IN EACH AREA IS THE CORRECT TILE AND HAS CONSISTENT/CORRECT PATTERN PER OUR NOTES, IS FREE OF EXCESSIVE LIPPAGE, CRACKS, CHIPS, SCRATCHES OR OTHER DEFECTS/DAMAGE, IS WELL BONDED AND FREE OF HOLLOW SOUNDING SPOTS OR MOVEMENT, HAS EVEN SPACING OF COLOR VARIATIONS OR VEINING SUCH THAT DUPLICATE TILES ARE NOT INSTALLED TOO CLOSELY TO EACHOTHER.
• WHERE APPLICABLE, TILE THAT REQUIRES SEALING IS SEALED

Here is the email body in code view:

***** CUSTOMER/JOBSITE INFORMATION:

TODAY'S DATE: @{outputs('Get_response_details')?['body/r8e2d96e0d19944d68a3bd0be33ec842a']}

BUILDER/CLIENT: @{outputs('Get_response_details')?['body/rbfea969df3784a2181c6053fc56cbddd']}

LOT/BLOCK/SUBDIVISION: @{outputs('Get_response_details')?['body/r2d987178b0164da6a47322b006ba1415']}

STREET ADDRESS: @{outputs('Get_response_details')?['body/r835b1e861dcd404b9cfaaf88ce628e94']}

***** TILE: HAS ALL TILE WORK LISTED IN THE SCOPE OF WORK BEEN COMPLETED?: @{outputs('Get_response_details')?['body/r8a5b4b3e9b4541788bb1c8b3d9af4571']}

IF NOT COMPLETE, WHAT TILE ITEMS ARE STILL NEEDING COMPLETED? @{outputs('Get_response_details')?['body/ra67bfd9c6bfb42fda822249973b6ed2a']}

FOR ALL TILE WORK THAT IS COMPLETE, PLEASE CHECK ALL THAT APPLY:

@{outputs('Get_response_details')?['body/r8c48692e3f1040a8ace86e1372ec63c0']}

FOR TILE, IF ANY OF THE ABOVE WERE NOT CHECKED, PLEASE EXPLAIN WHY AND ITEMIZE WHAT NEEDS TO BE DONE TO ADDRESS THESE ISSUES: @{outputs('Get_response_details')?['body/r184616375f8b446d8f931c1af652e095']}

***** HARDWOOD/LVP/LAMINATE:

HAS ALL HARDWOOD/LVP/LAMINATE LISTED IN SCOPE OF WORK BEEN COMPLETED?: @{outputs('Get_response_details')?['body/r60c4e934bdc0449eaaf784df22f87085']}

IF NOT COMPLETE, WHAT HARDWOOD/LVP/LAMINATE ITEMS ARE STILL NEEDING COMPLETED? @{outputs('Get_response_details')?['body/r8ae84af9f5854e49a0de513c905649a5']}

WHAT TYPE OF FLOOR VENTS ARE INSTALLED? @{outputs('Get_response_details')?['body/r5923c3b0bdad4819855d3c631f46466a']}

FOR ALL HARDWOOD/LVP/LAMINATE WORK THAT IS COMPLETE, PLEASE CHECK ALL THAT APPLY: @{outputs('Get_response_details')?['body/r9d169b8864094a8cba837879e032cf73']}

FOR HARDWOOD/LVP/LAMINATE, IF ANY OF THE ABOVE WERE NOT CHECKED, PLEASE EXPLAIN WHY AND ITEMIZE WHAT NEEDS TO BE DONE TO ADDRESS THESE ISSUES: @{outputs('Get_response_details')?['body/rb0d29eb33ea84296a3321cf3f3c0dd4d']}

***** COUNTERS:

HAVE ALL QUARTZ/GRANITE/PORCELAIN SLAB/LAMINATE COUNTERS LISTED IN THE SCOPE OF WORK BEEN COMPLETED?: @{outputs('Get_response_details')?['body/rb6f3a0d1d0ae4176a24ddbf8bd39998d']}

IF NOT COMPLETE, WHAT QUARTZ/GRANITE/PORCELAIN SLAB/LAMINATE COUNTER ITEMS ARE STILL NEEDING COMPLETED? @{outputs('Get_response_details')?['body/r82dac362859a44608de84ff717d05fa6']}

FOR ALL QUARTZ/GRANITE/PORCELAIN SLAB/LAMINATE COUNTER WORK THAT IS COMPLETE, PLEASE CHECK ALL THAT APPLY: @{outputs('Get_response_details')?['body/r68e9ea66286e47b2b11bd902d2072af3']}

FOR QUARTZ/GRANITE/PORCELAIN SLAB/LAMINATE, IF ANY OF THE ABOVE WERE NOT CHECKED, PLEASE EXPLAIN WHY AND ITEMIZE WHAT NEEDS TO BE DONE TO ADDRESS THESE ISSUES: @{outputs('Get_response_details')?['body/r03d22d9253994fcbb8d138c12f362186']}

***** SHEET VINYL/RUBBER:

HAVE ALL SHEET VINYL AND/OR RUBBER FLOOR INSTALLATIONS LISTED IN THE SCOPE OF WORK BEEN COMPLETED?: @{outputs('Get_response_details')?['body/r0de1b67454f3443a8d9af59b1e6bac48']}

IF NOT COMPLETE, WHAT SHEET VINYL AND/OR RUBBER FLOOR INSTALLATIONS ARE STILL NEEDING COMPLETED? @{outputs('Get_response_details')?['body/rb95b34a4b4e74c10ac543b58b49fa7fc']}

FOR ALL SHEET VINYL AND/OR RUBBER FLOOR WORK THAT IS COMPLETE, PLEASE CHECK ALL THAT APPLY: @{outputs('Get_response_details')?['body/r0a0d5ba7014d408bade5b6b972053042']}

FOR SHEET VINYL/RUBBER IF ANY OF THE ABOVE WERE NOT CHECKED, PLEASE EXPLAIN WHY AND ITEMIZE WHAT NEEDS TO BE DONE TO ADDRESS THE ISSUES: @{outputs('Get_response_details')?['body/r0366ea1f36a14eb9ba0b569964eb4724']}

***** CARPET:

HAS ALL CARPET LISTED IN THE SCOPE OF WORK BEEN COMPLETED?: @{outputs('Get_response_details')?['body/r7ae1313b8a3046b0accdce4a26264d72']}

IF NOT COMPLETE, WHAT CARPET ITEMS ARE STILL NEEDING COMPLETED? @{outputs('Get_response_details')?['body/rb2d4b36968444ef4bc71222eddffa828']}

FOR ALL CARPET WORK THAT IS COMPLETE, PLEASE CHECK ALL THAT APPLY: @{outputs('Get_response_details')?['body/ra965bbaee1d94649976ed55f35b111b8']}

FOR CARPET, IF ANY OF THE ABOVE WERE NOT CHECKED, PLEASE EXPLAIN WHY AND ITEMIZE WHAT NEEDS TO BE DONE TO ADDRESS THESE ISSUES: @{outputs('Get_response_details')?['body/r562d3008d0cb42daaeefea5caafcb134']}

***** GENERAL JOBSITE INSPECTION:

ARE INSTALLATION AREAS & GARAGE FREE OF LOOSE TRASH, DEBRIS, AND EXCESS INSTALLATION MATERIALS?: @{outputs('Get_response_details')?['body/r6f8cf1fe2d7c4fca85b58fe4d299a058']}

IS THE HOUSE STILL CLIMATIZED TO A LIVABLE TEMPERATURE AT THE TIME OF THIS INSPECTION? @{outputs('Get_response_details')?['body/re581d2544f604812bf765a89b5c13acb']}

LIST ANY MAJOR CONCERNS WITH THE STRUCTURAL INTEGRITY OF THE JOBSITE DISCOVERED DURING YOUR INSPECTION (I.E. FLOODING, ROOF LEAKS, MUST ODORS, PORTIONS OF OUR INSTALLS THAT HAVE BEEN REMOVED TO MAKE WAY FOR OTHER TRADE'S REPAIRS, MISSING WINDOWS, DOORS, GARAGES, ETC.): @{outputs('Get_response_details')?['body/r6fbb3d46fcda437dae162729adf1204a']}

***** SUMMARY:

POST WALK COMPLETED BY: @{outputs('Get_response_details')?['body/r1943da4423ae457c908fd0c2b5cd81d9']}

PLEASE CONFIRM PICTURES WERE TAKEN OF ANY ITEMS THAT REQUIRE REPAIR/REPLACEMENT/TOUCH-UP LISTED IN THE SECTIONS ABOVE: @{outputs('Get_response_details')?['body/ra6580f0683f34ed8beb8a4cbefc78826']}

[ManishSolanki]

Hi,

Pls try below expression for that particular field in email body. Expression needs to be added in the expression box as shown below:

concat('<li>',join(outputs('Get_response_details')?['body/r8c48692e3f1040a8ace86e1372ec63c0'],'<li>'))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[Feathergun]

I got this failure when attempting your solution:

[ManishSolanki · Accepted solution]

Hi,

Pls try this expression:

concat('<li>',join(json(outputs('Get_response_details')?['body/r8c48692e3f1040a8ace86e1372ec63c0']),'<li>'))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.