Can I save the generated PDF as an attachment inside a list item

(1) Share

Report

Posted on by johnjohnPter

1,857 Season of Giving Solutions 2025

I have a SharePoint list form which have attachments + the below formula to generate PDF:-

Set(
 varWorkOrderPDF,
 PDF(
 'PDF container',
 {ExpandContainers: true}
 )
);

When submitting the form, i am generating the PDF, but how i can add the generated PDF as an attachment inside the list item? can i do it inside the power apps?

When i added the following formula inside the Items property of the attachment control:-

and i submit the form, i will get an error that the "Field 'id' is required", as follow:-

any advice? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @johnjohnPter ,

I do not believe you can do it directly in Power Apps, however if you look at the second option in this blog of mine and send the ID of the record as well, you should be able to add the file as an attachment (instead of emailing it as in the blog).

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
Verified answer

RouxJMM on at

Like (3)

Report
Copy link

Link copied!
Try this.
Set(varAttachment, { DisplayName: Substitute("FileName" & Text(Now(),"yyyy-mmm-dd hh:mmm AM/PM") & ".pdf", ":","_"), Id: Substitute("FileName" & Text(Now(),"yyyy-mmm-dd hh:mmm AM/PM") & ".pdf",":","_"), Value: Substitute(JSON(varWorkOrderPDF,JSONFormat.IncludeBinaryData),"""","")});
and set the items to
varAttachment

Was this reply helpful? Yes No
johnjohnPter 1,857 Season of Giving Solutions 2025 on at

Like (1)

Report
Copy link

Link copied!

@RouxJMM this worked thanks a lot 🙂

Was this reply helpful? Yes No
johnjohnPter 1,857 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@RouxJMM this top working 2 days ago, where the PDF will not get added to the attachment control ? any advice?

Was this reply helpful? Yes No
RouxJMM on at

Like (1)

Report
Copy link

Link copied!

Still works for me. Make sure the PDF function is enabled in the settings.

Was this reply helpful? Yes No
johnjohnPter 1,857 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@RouxJMM why saving it as an attachment might not be the best approach? can you elaborate more please?

Was this reply helpful? Yes No
CuriousCat_ on at

Like (0)

Report
Copy link

Link copied!
Hello, where exactly should I put this ?
Set(varAttachment, { DisplayName: Substitute("FileName" & Text(Now(),"yyyy-mmm-dd hh:mmm AM/PM") & ".pdf", ":","_"), Id: Substitute("FileName" & Text(Now(),"yyyy-mmm-dd hh:mmm AM/PM") & ".pdf",":","_"), Value: Substitute(JSON(varWorkOrderPDF,JSONFormat.IncludeBinaryData),"""","")});
Thank you

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@johnjohnPter ,

I just posted a working solution on this thread.

Was this reply helpful? Yes No
RouxJMM on at

Like (2)

Report
Copy link

Link copied!
It goes after the PDF has been created. It could go like this:

Set(
varWorkOrderPDF,
PDF(
'PDF container',
{ExpandContainers: true}
)
);

Set(varAttachment, { DisplayName: Substitute("FileName" & Text(Now(),"yyyy-mmm-dd hh:mmm AM/PM") & ".pdf", ":","_"), Id: Substitute("FileName" & Text(Now(),"yyyy-mmm-dd hh:mmm AM/PM") & ".pdf",":","_"), Value: Substitute(JSON(varWorkOrderPDF,JSONFormat.IncludeBinaryData),"""","")});

and set the items property of the attachment control to:
varAttachment

If the content worked / was useful, please consider giving it Thumbs Up

Was this reply helpful? Yes No
VaibhavBhardwaj 8 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much!! Its working flawlessly, I was able to capture the whole form (long scrollable form) as the PDF and save it as attachment in the list.

Was this reply helpful? Yes No