How to place string before an array?

(0) Share

Report

Posted on by highlyAnnoyed

Is there a way to place text - pulled from a list - before an array?

For instance, my current table looks like this:

Question user needs to answer?
Answer to question.

I am looking to include something that would look like this:

SECTION ONE

Question user needs to answer?
Answer to question.

SECTION TWO

Question user needs to answer
Answer to question.

Ideally, this text would only be visible if the array is not empty. If it is empty, no section header for that array.

My use case is as follows: I'm creating a document by generating a custom table. The values are stored in a Dataverse table, and the user adds records through a PowerApps canvas app. There are eight sections of this form, though the user may not fill out all questions. In the form, they are routed to different sections based on their answers. The requirements are that by the end of this form, they will have a document that only includes the sections and corresponding questions that they answered.

Since I am creating the table dynamically, I had to create a reference list in SP that stores all the internal names of the fields from the Dataverse. I have a 'Apply to all' condition that cycles through all the internal names in SP, checks if they exist in the Dataverse [Get row by id query], and if they do, it grabs the answer and corresponding question from each section and appends this information to an array. There are eight arrays to correspond with the eight sections.

I need to be able to insert a row heading at the beginning of each section Array. Here are the actions in my flow that create the table:

The concat formulas are:

concat('<tr><td><p><b>',item()['Question'],'</b></p><p>', item()['Answer'],'</p></td></tr>')

In the join I am doing the following:

join(body('section_one_select'),decodeUriComponent('%0A'))

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

highlyAnnoyed 11 on at

Like (0)

Report

Okay never mind... just set the values to what I needed when I initialized the variable.

EDIT: Never mind again, realized this doesn't really meet the ask. I need to be able to only show the headers if the array is not empty, and this will always have content in the array. ugh, back to the drawing board.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Hopefully this will get what you're after.

Below is the full flow. I'll go into each of the actions.

The three array variables contain your questions and answers. Note that arrSectionThree is empty so we don't want a section header for it.

The three Selects are the same as what you had before. The expression used is:

concat('<tr><td><p><b>',item()['Question'],'</b></p><p>', item()['Answer'],'</p></td></tr>')

Compose builds up the HTML table. The expressions used are:

if(not(equals(length(variables('arrSectionOne')),0)), concat('<tr><th>Section One</th></tr>', join(body('Select_One'), '')), null) if(not(equals(length(variables('arrSectionTwo')),0)), concat('<tr><th>Section Two</th></tr>', join(body('Select_Two'), '')), null) if(not(equals(length(variables('arrSectionThree')),0)), concat('<tr><th>Section Three</th></tr>', join(body('Select_Three'), '')), null)

Compose Style has some CSS to style the table.

<style> table { border-collapse: collapse; width: 100%; } table td, table th { border: 1px solid #ddd; padding: 5px; text-align: left; } table th { background-color: #1C6EA4; color: white; } </style>

And finally, Send an email contains the output from the Compose Style and Compose.

The email for this example would look like:

Was this reply helpful? Yes No
highlyAnnoyed 11 on at

Like (0)

Report

Wow, thank you so much for this! I actually ended up doing a much less elegant [and less efficient] way to do the same thing. Basically using conditional actions to check if the section content arrays were empty, then if they weren't, setting a variable to the section header content then adding that content in a select and adding the select to the compose. I edited it to be somewhat similar to yours and used the empty() function instead of the length. Thanks so much!!

Was this reply helpful? Yes No