Power Automate HTML to PDF

(0) Share

Report

Posted on by firda59

372

I have flow like this,

Flow P.Automate

and I have database like this,

Database

This is the detail of the flow,

Detail flow

So, I want that HTML can grab all data based on 'Job No' from the database. When I choose, Job No A.23.3010, then the data on pdf just the data which has Job No A.23.3010.

I try used formula No_x0020_Job eq '[TextInput2]' to call all data with that Job No. TextInput2 is the Job No control in PowerApps. But it cant work, can you help me to solve this problem? Thanks in advance.

Categories:

Connectors

General Questions

Using Apps Using Formulas

All responses (11)

Answers (1)

Verified answer

SudeepGhatakNZ 14,123 on at

Like (1)

Report

Re: Power Automate HTML to PDF

This is my list

This is my flow

Final Output

The sample is attached.
firda59 372 on at

Like (0)

Report

Re: Power Automate HTML to PDF

Yes, I need a sample, so I can follow the flow like what you explain to me. Thanks in advance
SudeepGhatakNZ 14,123 on at

Like (0)

Report

Re: Power Automate HTML to PDF

There are several things that don't look right.

Intialize variable should be at the top of flow. It should be of type array.

Use Append variable inside the loop.

Use select and create HTML table actions to create the html

Finally convert it to HTMl

Do you need a sample?
firda59 372 on at

Like (0)

Report

Re: Power Automate HTML to PDF

here it is
compose is contain HTML text table, and this is what I insert on variable
do you know whats wrong with this?
SudeepGhatakNZ 14,123 on at

Like (0)

Report

Re: Power Automate HTML to PDF

What are you setting inside the variable?
firda59 372 on at

Like (0)

Report

Re: Power Automate HTML to PDF

Ok, thank you. And there's another problem. When I wanna save this flow, I got this:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Initialize_variable' at line '1 and column '8325' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Initialize_variable' to be referenced by 'repeatItems' or 'items' functions.'.'
How to solve this problem?
SudeepGhatakNZ 14,123 on at

Like (1)

Report

Re: Power Automate HTML to PDF

If you are triggering the flow from PowerApps, you must be sending a parameter to it?

How To Trigger A Power Automate Flow From PowerApps (c-sharpcorner.com)
firda59 372 on at

Like (0)

Report

Re: Power Automate HTML to PDF

In my powerApps, there is no varText. How to bring it up?
SudeepGhatakNZ 14,123 on at

Like (1)

Report

Re: Power Automate HTML to PDF
firda59 372 on at

Like (0)

Report

Re: Power Automate HTML to PDF

can you give me example for this 'Your PowerApps variable form the trigger'. I dont understand how to define this thing