Answered

How to attach a generated PDF to a form for Sharepoint submit?

(1) Share

Report

Posted on by PimJ

Hello, I have an interesting question about how to submit a generated PDF into a Sharepoint list, by using a form.

First, I have successfully generated a PDF from a container, which contains a gallery with data. This is done with the following (new) PDF-command:

Set(pdfStemReport,PDF(contStemReport,{ExpandContainers:true}));

So, after this command, I have stored the PDF in my variable "pdfStemReport" with datatype Blob. I know that the file is generated, because I can check with the PDF-viewer.

The goal is to store this generated PDF in a new item of my Sharepoint list and therefor I created a form, which is connected to that list. So, that form contains fields for all the Sharepoint columns, including the Attachement field.

My idea was to load the generated PDF as default value in the Attachement datacard of the form and then submit the form to Sharepoint, so that all data comes in my list, including the attached PDF. However, this does not work because I get the following error when setting the PDF-file as default value for the Attachement datacard:

So, I ave no idea if this is possible or how I should do this...

Any help is much appreciated!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

365-Assist 2,324 Moderator on at

Like (0)

Report

I would suggest using Power Automate. The Microsoft documentation explains how to do this -> Work with the PDF function (experimental) - Power Apps | Microsoft Learn

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
PimJ 65 on at

Like (1)

Report

Thanks for the suggestion to use Power Automate, but this places the generated PDF in a Sharepoint document library, while my request is to have it as attachement in my Sharepoint list, together with other data.

In fact my question is quite simple: how can I "connect" the generated PDF (the Blob-data?) to the Attachements- datacard of my list-form, so that I can submit this directly to a new list item?

Was this reply helpful? Yes No
Verified answer

365-Assist 2,324 Moderator on at

Like (0)

Report

Apologies for the confusion. I made a video on the topic you want -> Power Apps- Why I stored documents in a List rather than a SharePoint Document Library. - YouTube

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
PimJ 65 on at

Like (1)

Report

Thanks a lot Darren, this is very helpful for me!
I was completely new to Power Automate, but I like the way how it works and I'm happy with all the features that it provides. I discovered that it is possible to add the generated PDF as an attachement to a Sharepoint list, but I also like the option to save the PDF to a Document Library - with additional doc. attributes being set! It seems that the Document Library is also kind of List, which gives all the same options like sorting, grouping and filtering.
So yes, I learned a lot - thanks again for helping me in the right direction!
Regards, Pim

Was this reply helpful? Yes No