Multiple TextInput records from PowerApps to HTML table within Flow with a click of a button

[AlexisCh]

Hi all,

I would love some help.

I have created a PowerApps with three TextInput (TextInput1, TextInput1_1 and TextInput1_2). All I want is with a click of button to trigger a Flow so I can export records from multiple TextInputs into an HTML table.

My Flow is called HTMLtoPDF.

What should I type under the "OnSelect" for the button within the PowerApp? I currently have the following:

<p>HTMLtoPDF.Run(TextInput1.Text, TextInput1_1.Text, TextInput1_2.Text)</p>

What should I type within the table in the HTML below?

<p> <table>
<tr>
<td>Column 1</td>
<td>{{TextInput1.Text}}</td>
</tr>
</table> </p>

Please see screenshots attached

[v-dezhili-msft · Accepted solution]

Hi @AlexisCh ,

You can try to write your html text in compose in flow.

Below is my test for your reference.

Best Regards,

Dezhi

[AlexisCh]

Hi Dezhi,

much appreciated. It works great!

Have a couple more questions.

1. What if I have a mix of controls. For example one textInput, one drop down list and one date. Can I pass dropdown selection to Flow? For example can I have something like this > HTMLtoPDF.Run(TextInput1.Text, DropDown1.List, Date1.xxx). I don't know the Syntax for dropdowns or dates. However, if that doesn't work, I plan to convert everything to Text so I can pass all my records to Flow.

2. Do you know whether I can use some CSS code in the HTML code within the "Compose" to improve the look of the table?

Many thanks
Alex

[Shavar_Scott · Accepted solution]

@AlexisCh , yes. You can use CSS code in the HTML to style your table. 

Here is an example:

That will format your table as below:

For more table formatting tips visit https://www.w3schools.com/html/html_tables.asp

[AlexisCh]

Hi @v-dezhili-msft Dezhi or anyone who might know,

Do I need to add a dynamic Content/Expression under the "Body" ?

I tried your solution, the HTML file works fine. However, the PDF file cannot be opened. I wonder whether I need to add dynamic content/Expression to the "Body" as shown in the screenshot.

Many thanks in advance for any help.

[Shavar_Scott · Accepted solution]

@AlexisCh ,

Try putting the file content generated from the "Convert file using path" step into in the File Content field.

Also, ensure that the file name is being stored with .pdf on the end.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[AlexisCh]

Amazing! Works great!

[AlexisCh]

@v-dezhili-msft Hi again,

this solution works great when you have less than 20 TextInputs.

Unfortunately I have more than 20 inputs in my original app. Is there a work around for when we have more than 20TextInputs?

There are limitations within the PowerApps and Flow/PowerAutomate.

Many thanks again for your help.