cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
G99
Post Prodigy
Post Prodigy

Place all attachments (pictures only) in to 1 PDF

hello,

 

I am not at all sure if this is possible. I have for previous canvas apps PDF the data from Power Apps, using Power Automate.

I now have a requirement to place all the attachments (SharePoint is the data source) a user uploads in the app and export them into the same PDF as the data (text). I am not sure if this has been attempted, but I will be restricting users to only be able to upload image file types in the attachment control.

In theory I expect this is possible but cannot find the right information online 

 

Thank you

 

 

22 REPLIES 22

@G99 ,

Your convert file using path seems to be different. I can assure you it works if you follow the steps in the Flow I posted.

Hi  @WarrenBelz

 

I've double checked and I am using the same as what you have in the last screen shots you provided as there is only 1 convert file using path option I can choose from.

 

I thought maybe the issue was related to the path field, but too I assume can only be the Outputs from the create file before this action

 

Could you please do me a huge favour on top of all the help you have provided, hover over both the File Path field and File Content field and check to see what they are pointing to. I can't seem to think anything else is different?

G99
Post Prodigy
Post Prodigy

Hi @WarrenBelz 

 

I see where the issue was,  in your 2nd instructions you were using body in the file content but in your original instructions you had set it to file content. I was looking at you 2nd set of instructions

 

The PDF opens fine, Thanks so much

 

In the PDF there is a bunch of HTML and I'm unsure where it's come from!

Looks like the Base64 of all the images in its raw format is somehow being displayed in the PDF, I don't see it in the html file, but not sure if it would show in a html file - I cant figure out how to get rid of it from the PDF as I cant see how its getting there

 

<!DOCTYPEhtml><html><body><imgsrc="data&colon;image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/

Hi @G99 ,

Flow seems to automatically change this (but it does not change the functionality)- you will find yours does the same. You have to use the File Content (as you do in any Flow resolving an image) - I have fixed the original.

This is solved now?

G99
Post Prodigy
Post Prodigy

Hi @WarrenBelz 

Yes its functioning but with a problem, the base64 raw text is also coming through in the PDF, I have no idea where this is coming from, would you know, and do you get the same behaviour?

Hi @G99 ,

Below is the code as shown in the hover over

WarrenBelz_0-1641546737522.png

WarrenBelz_0-1641552824809.png

 

These are really the only two that affect the content of the image output.

 

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.

Visit my blog Practical Power Apps

 

 

G99
Post Prodigy
Post Prodigy

I compared your first post with the your second and found a slight difference

Your last screen shot and of course my code was missing this, Of course you have this in the first post so thank you sooo much for all your help:

 

G99_0-1641551604575.png

 

G99
Post Prodigy
Post Prodigy

Hi @WarrenBelz 

 

This post helped but I have the issue of some files being more than 2MB.

Would you have any workarounds to this?
Seeing suggestions online about using premium 3rd MS Word connector... but not sure that will work either.

Hi @G99 ,

The 2mb is a "hard" limit and no workaround using this process exists as far as I know. You could do it with a Word Merge, however you would have to know the number of pictures as you cannot merge an image object and inside a Table object in Word.

Hi, thanks for sharing your solution.
I am wondering if there is anything we can do with pictures bigger than 2MB from the gallery to resize before uploading to the SharePoint list to comply with the 2MB max size? In powerApps or running a flow?

Best Regards. 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,176)