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

[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!

[365-Assist · Accepted solution]

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

[PimJ]

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?

[365-Assist · Accepted solution]

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

[PimJ]

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