Unanswered

FORMULA MISSING A COLUMN

(0) Share

Report

Posted on by joieeee09

Hi, I am currently working on a contract generator via Power Apps. I have been using this code for my other forms and it works fine but for this specific form, there seems to be an error. This is the code that I have been using for all contract forms:

Set(PDFvalue, PDF(APGSContract, {Size: PaperSize.A4}));
Set(fileNameSuffix, Substitute(Text(Now(), DateTimeFormat.UTC), ":","-"));
Set(DownloadLink, ThailandPDFExporter.Run(Concatenate("Agreement_" & fileNameSuffix & ".pdf"),
{
file: {
name: Concatenate("Agreement_" & fileNameSuffix & ".pdf"),
contentBytes: PDFvalue
}
}
).link);
Launch(DownloadLink);

For my previous forms, there is no issue. But for this new form, the error encountered is:

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

WarrenBelz 153,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @joieeee09 ,

I cannot see your Flow, but assuming you are simply using the contentBytes output as an image content, there is nothing wrong with the structure you have posted. How are you using it in the Flow ? You can also cut all that back a bit

Launch( ThailandPDFExporter.Run( "Agreement_" & fileNameSuffix & ".pdf", { file: { name: "Agreement_" & fileNameSuffix & ".pdf", contentBytes: PDF( APGSContract, {Size: PaperSize.A4} ) } } ).link

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
joieeee09 on at

Like (0)

Report
Copy link

Link copied!

When I use the code that you have posted, I still get the same error that there is a missing column. Please check my flow below, I have been using the same flow on my previous forms and it works, but I always get an error with my current form.

Was this reply helpful? Yes No
WarrenBelz 153,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@joieeee09 ,

The error is saying that the contentBytes field in your file Table is not the correct type, however when I test the same code here (I actually use something very similar in a prod app), it works fine - what exactly is APGSContract in your app ?

Was this reply helpful? Yes No
joieeee09 on at

Like (0)

Report
Copy link

Link copied!

APGSContract is the name of my data card under a fluid grid. I put the code on the OnSelect of the print icon on the top right part of the page.

Basically what it does is that when you click on the print icon, it will display the PDF document in new tab that the user can print or download.

It is weird because I have done this with my previous forms and it worked. But on this specific form, I always get an error.

Was this reply helpful? Yes No
WarrenBelz 153,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@joieeee09 ,

Maybe try putting it in a Container and PDF the container.

Was this reply helpful? Yes No
joieeee09 on at

Like (0)

Report
Copy link

Link copied!

I tried putting it in a container but the error is still the same for contentBytes.

Was this reply helpful? Yes No
WarrenBelz 153,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@joieeee09 ,

Then it appears that the new PDF function does not resolve the Fluid Grid, so there is not much you can do here.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
joieeee09 on at

Like (0)

Report
Copy link

Link copied!

Is there any way or other possible solution that I can use to make my form printable? The user must view the document and has an option to print the document or download.

Was this reply helpful? Yes No
WarrenBelz 153,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@joieeee09 ,

Other than the Print function (which may not suit your purpose) or doing something in HTML and converting it to PDF with a Flow, nothing else I know of.

Was this reply helpful? Yes No