cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
G99
Post Prodigy
Post Prodigy

Place all attachments (pictures only) in to 1 PDF

‎12-06-2021 07:25 AM

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

 

 

Labels:
Message 1 of 23
573 Views
0 Kudos
22 REPLIES 22
WarrenBelz
Super User
Super User
In response to G99

‎01-06-2022 03:26 AM

@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.

Message 11 of 23
115 Views
G99
Post Prodigy
Post Prodigy
In response to WarrenBelz

‎01-06-2022 04:21 AM

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?

Message 12 of 23
111 Views
0 Kudos
G99
Post Prodigy
Post Prodigy

‎01-06-2022 04:31 AM

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/

Message 13 of 23
112 Views
0 Kudos
WarrenBelz
Super User
Super User
In response to G99

‎01-06-2022 12:38 PM

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?

Message 14 of 23
104 Views
0 Kudos
G99
Post Prodigy
Post Prodigy

‎01-06-2022 11:32 PM

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?

Message 15 of 23
99 Views
0 Kudos
WarrenBelz
Super User
Super User
In response to G99

‎01-07-2022 01:13 AM

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

 

 

Message 16 of 23
94 Views
0 Kudos
G99
Post Prodigy
Post Prodigy

‎01-07-2022 02:18 AM

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

 

Message 17 of 23
87 Views
0 Kudos
G99
Post Prodigy
Post Prodigy

‎03-29-2022 07:07 AM

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.

Message 18 of 23
69 Views
0 Kudos
WarrenBelz
Super User
Super User
In response to G99

‎03-29-2022 01:41 PM

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.

Message 19 of 23
65 Views
LeandroTF
Frequent Visitor
In response to WarrenBelz

‎04-23-2022 12:09 PM

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. 

Message 20 of 23
37 Views
0 Kudos

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.

View All
Users online (4,176)