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:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate HTML to PDF

Hi,

The filter should be

No_x0020_Job eq 'Your PowerApps variable form the trigger'

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

Re: Power Automate HTML to PDF

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional 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)

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate HTML to PDF

What are you setting inside the variable?

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional 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?

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No