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

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (3)

Sort by

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @AlexisCh ,

You can try to write your html text in compose in flow.
Below is my test for your reference.

Best Regards,
Dezhi

Was this reply helpful? Yes No
AlexisCh 17 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Shavar_Scott 175 on at

Like (2)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
AlexisCh 17 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Shavar_Scott 175 on at

Like (2)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
AlexisCh 17 on at

Like (0)

Report
Copy link

Link copied!

Amazing! Works great!

Was this reply helpful? Yes No
AlexisCh 17 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No