Hi @Axylum,
It is difficult to understand the issue without seeing what you have created already. How are you triggering the flow? You say that there are over 150 columns, do you want all of the data that has been produced from the form or just a single instance?
How to write a good forum post
I'm going to assume that it is the email is the output of a single form and that the trigger is "when a response is submitted".
After your trigger, add an action to "List rows present in a table"
Fill in the location, Document Library, File and Table to the excel file where your responses are captured. Show advanced options and add "ID eq (Dynamic content from when a new response is submitted) Response ID" in the filter query
Next add a "Create HTML table" action and add (Dynamic Content from List rows present in a table) value
Now add a compose action
<style>
table {
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
text-align: left;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
}
table tbody td {
font-size: 13px;
}
table thead {
background: #1C6EA4;
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 15px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
</style>
After style, add (Dynamic content from Create HTML Table) Output
Now add the Dynamic Content from Compose to the body of your email
This should produce a nice CSS formatted table for your email, automatically adding all of the columns from the form into it automatically.
If you have issues with the formatting of the table, you can play around with the CSS (in the compose action) or remove it altogether and just add the output of the Create HTML table into the email (Although this won't look very nice)
If I have assumed incorrectly what your trigger is or what you want to produce in your email, this should give you the tools to amend and create what you need
━━━━━━━━━━━━━━━━━━━━━━━━━
If I have answered your question, please mark your post as Solved.
Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.
If you liked my response, please consider giving it a thumbs up. Thank you!
