Super easy method to Display PDF Files Stored in SharePoint in Power Apps PDF Viewer

No video

Super easy method to Display PDF Files Stored in SharePoint in Power Apps PDF Viewer

Рет қаралды 41,777

Күн бұрын

Super easy method to display PDF Documents stored in a SharePoint document library in a PowerApps PDF Viewer. This method does not use any flows in PowerApps, but does use a Flow to populate additional content in the Library.
Thanks to Reza Dorrani for his video on this subject:
• PowerApps PDF Viewer S... which inspired this one.
Also thanks to Bruce365 for this post which enabled this method:
www.bruce365.c...
Let me know how you get on in the comments! I love this method.
If you found this solution useful, I'd appreciate a donation to the channel:
www.buymeacoff...

Пікірлер: 140

@carrsgroup3659 2 жыл бұрын

This is incredible. I started looking for a solution for this over a year and a half ago, and revisited it a few times. This works wonderfully. Great work again

@Ironhead80 Ай бұрын

Most elegant method I've seen. Thank you sir!

@PaulieM 28 күн бұрын

I’m glad you like it - it is very neat.

@edjk6278 5 ай бұрын

This is brilliant. I too have seen Reza’s method and battled a bit..not easy for long term support. This is far more straightforward. I’m a big fan of your work and continue to learn from videos. Don’t Stop…. Thanks mate!

@PaulieM 5 ай бұрын

Thank you! I will keep going!

@JackCastro Жыл бұрын

Best solution yet! While I adore @RezaDorrani, this one simplifies, err, updates PDF viewer capabilities. Y'all are awesome! Thanks so much! ♥

@PaulieM Жыл бұрын

Thank you Jack, appreciate it.

@isvisvisvisv 4 ай бұрын

Thank you Paul, your solution was really helpful even when I am starting with Power Automate and Power Apps. Appreciate it!

@PaulieM 4 ай бұрын

Thanks for feedback, glad it helped.

@ConnorMcLarnon Жыл бұрын

Thanks a lot, I was also on Rezas vid but was having a lot of difficulty with PDF, I now have used a combination of both methods :)

@PaulieM Жыл бұрын

It’s a nice method. I have a new method I need to implement actually

@monicalindin1392 Жыл бұрын

Fantastic tutorial, thank you. I've been working on this issue for months and your solutions works beautifully, thank you for sharing your knowledge.

@PaulieM Жыл бұрын

Thank you for the kind feedback 👍🏻

@janurbanek1127 Жыл бұрын

best solution, no buttons calling flows etc. Love it

@myriaadamidou9136 2 жыл бұрын

Thank you, thank you, thank you, your solution is the only thing that worked for me, I tried everything! Well done!

@krystiank9583 2 жыл бұрын

Thank you! I had a big problem with download file content from sharepoint, your video help me a lot!

@csmtiltm5910 4 ай бұрын

So good, this is the easest I've found!! Thanks x 1000...0000

@PaulieM 4 ай бұрын

Thanks for the feedback, it really is an easy method. Glad it helped.

@emma6596 2 жыл бұрын

It works perfectly, thank you very much for sharing!

@PaulieM 2 жыл бұрын

Happy to hear! I love using this method.

@MynoroKaneco 2 жыл бұрын

Muito bom Parabéns, vi vários vídeo e esse foi o melhor para gerar pdf.

@brendanv666 Жыл бұрын

Hi Paulie, Thank you so much for that. A very simple way of producing the PDF.

@PaulieM Жыл бұрын

You're very welcome!

@VictorIrikefe 9 ай бұрын

This is a great tutorial... very smart way to execute this. Thanks so much.

@PaulieM 9 ай бұрын

Thanks - glad it helped you out

@applecartdigital55 2 жыл бұрын

Nice work paul, works a treat

@meshmut 5 ай бұрын

Saved the day my Friend

@thegame4988 3 жыл бұрын

Thank you for this amazing solution. It will come extremely useful for me in a project I have been working on.

@PaulieM 3 жыл бұрын

Really pleased to hear that. It works so well, I’m using it for a project I am building right now.

@gregoirepesenti 5 ай бұрын

Hello, amazing solution. now, what if I need to filter the gallery based on a label text ou combox box selected value ?

@adriaanaylsworth263 Ай бұрын

I tried following your steps. But the input for the Compose action is only the file, unlike yours.

@JoaoSilva-so7xz 3 ай бұрын

What about if I wanna use a sharepoint folder inside Documents, instead of a proper List?

@jesseveentjer2075 2 жыл бұрын

Cool solution, thanks for sharing

@itcommander709 2 жыл бұрын

Great and thank you for showing solution

@zc8347 Жыл бұрын

Wow! Works great 🎉🎉🎉

@evandrodossantosYou 6 ай бұрын

Hi. congratulations! It´s an amazing flow. I tried to apply it into a Sharepoint list, but it didn´t work yet. In my case, when a file is created in Sharepoint, I create a item in sharepoint list. This sharepoint list is the source for powerapp. Any clue to link PDF viewer from sharepoint list?

@17blackshadow17 Жыл бұрын

Hello, thanks for the very explanatory video but I still have a problem. I followed all the steps but in the end, although there are no errors, the pdf viewer remains black...

@victoralbertodurangutierre5451 6 ай бұрын

I'm not able to select dataURI any longer, any suggestion?

@jainabhinav2780 3 ай бұрын

any way we can merge the pdf's without any third party connector. or any way we can convert pdf to html without any connector?

@jeffscott9335 2 жыл бұрын

Great idea, but I can't get it to work. The Update File Properties step returns "'datauri(base64ToBinary(outputs('Get_file_content')['$content']))' cannot be evaluated because property '$content' doesn't exist, available properties are 'statusCode, headers, body'."

@aramayomurrayjoaquin2094 Жыл бұрын

I have a doubt plz, i wanted to know if its posible to do zoom the pdf, no matter what the way of uploading the pdf to powerapps, i only want to be able to make a zoom on my pdf viewer on powerapps, this is because i have a pdf that contents images intead of text, if someone knows or has an idea to make it possible ill be glad to you, tnx!

@PaulieM Жыл бұрын

The PDF Viewer has the zoom function built right into it.

@DeShonClark 3 жыл бұрын

Still chiseling away trying to embedded images in a Word doc...this may be the missing piece for signatures...I think this solution may get us closer if we can get Word to render binary

@PaulieM 3 жыл бұрын

Hey DeShon, please remind me why this isn’t possible? Can you not just use an image control in word to loads a signature in?

@DeShonClark 3 жыл бұрын

Hey Paul, does the image control require premium connector?

@PaulieM 3 жыл бұрын

@@DeShonClark Yes - I will have another play this week and see if I can force something in! :D

@DeShonClark 3 жыл бұрын

I'm getting a lot of comments on my side for this. I'm think the easiest may be to use a premium connector but design it in a way you only need premium for a service account and not all users. Just keep me posted Paul! Thank you.

@PaulieM 3 жыл бұрын

I’ve done it - will be posting info this week.

@sergiomendes63 2 жыл бұрын

How can I create a variable in the flow from the power app to send a mail with the pdf file attachment, to the user who types in the text box?

@pranaykumar7623 2 жыл бұрын

What is the scenario for the files already existing on the library? please let me know the solution for this.

@carrsgroup3659 2 жыл бұрын

You can still run the flow on existing files to populate that URI field. You would use a combination of get files then get file content.

@vinisz Жыл бұрын

I have data:application/pdf when doing "get file content" (so different then the JSON output shown in the movie) , can I convert data:application/pdf to data/octetstream ?

@dixitjoshi3947 8 ай бұрын

but why large number of pdf's are not loading in gallery

@kf2280 2 жыл бұрын

Thanks for this video I created a power app for user to attach PDF file and data will save all combined files to share point but I want to save PDF files in separate folders for each factory. How can this be done? Thank you very much.

@johnnytao7588 3 жыл бұрын

Another great learning video. :-)

@vw3538 2 жыл бұрын

My inputs/outputs are not displayed under my compose. How do I get them to display.

@itforeveryone5426 2 жыл бұрын

How to push notification for user? and user click push notification after view file pdf in gallery or deep link or navigate sub screen? thanks. help me

@DesOwen 2 жыл бұрын

Nice one Paul.

@DarrenCarlson-zv6ec 4 ай бұрын

When I attempt this, PowerAutomate doesn't show the encoded string value in the Inputs and Outputs parameters of the Compose step. I'm sure I'm making some rookie PowerAutomate error but can't figure out how to fix it. What it is showing is a link which leads to an azure address that actually displays the content of the PDF I'm testing with.

@DarrenCarlson-zv6ec 4 ай бұрын

I proceeded because that step wasn't really necesary anyway. But although the flow seems to do exactly what your flow did/does, when I put the value from the URI into a PDFViewer.Document property, it displays a message saying it can't open the file and shows a link to open in a browser.

@danishislam692 2 жыл бұрын

Thank you for sharing this but my pdfs are loading very slow (30-40 seconds). I am getting dataURI value on screen visible property (as i am showing pdf on different screen than the gallery). any suggestions ?

@manid2530 2 жыл бұрын

Hi, did you figure this out ?

@danishislam692 2 жыл бұрын

@@manid2530 actually it seems to be the internet issue and also I saved my datauri values in a seperate list than library, so now it seems to be fine

@rodelski5514 2 жыл бұрын

@@danishislam692 hi...im having the same issue. Can you help explain this a little further? Like saving datauri to a seperate list? Also, can you filter that only pdfs can generate datauri? Thanks a lot

@mumialpi 2 жыл бұрын

Hello, we keep some 10-500 mb of pdf portfolios on our sharepoint library. Due government network limitation, we have to download each file to review and digitally sign, then upload again. Can you think of a work around for pdf portfolio to open directly in browser to be reviewed and digitally signed by PKI cert? My researched showed that there is an add-on by Adobe for SharePoint but Air force Sharepoint does not allow this add on to be added. Looking for workarounds. Thank you

@amirulfaiz9860 2 жыл бұрын

Hi Paulie, Superb! thanks for the video its work at my end. However, i have encountered 1 issue when I tried to upload more documents in that SharePoint (roughly around 9 documents) and looks like the sharepoint is jammed. Is there anyway that can solve this issue?

@PaulieM 2 жыл бұрын

Just change the view not to show the column containing the encoded document.

@amirulfaiz9860 2 жыл бұрын

Hi @@PaulieM thanks! it works at SharePoint. However, when I try to access the powerapps using a mobile phone it is still slow for the gallery that shows all the list of pdf to appear (around 20-30 seconds). Any idea to solve it?

@PaulieM 2 жыл бұрын

@@amirulfaiz9860 Are you storing the PDF in the same list that you are creating the gallery from? This is what makes it slow. In my example the list containing the PDF data contains only the PDF data. The gallery is loaded from a separate list which contains only the ID of the PDF list item. So that means when a record is selected the PDF library is always filtered to just one record.

@rodelski5514 2 жыл бұрын

@@PaulieM hi, really appreciate if you can explain this workflow a little more detailed. I'm pretty newbie to this powerapps and it would be great to see how you did this. thanks

@diraneserges6076 2 жыл бұрын

Great tutorial please it is possible to implemant the deleting ooperation

@fanzfanzilla Жыл бұрын

Thank you for the video. How big file can be stored in the sharepoint field? Is there a file size limitation?

@BalajiMuralikrishnan 3 жыл бұрын

Amazing idea and super implementation. Thank you Will the same approach work for other file formats?

@PaulieM 3 жыл бұрын

Yes, for images etc this will work (but obviously not in the PDF viewer control)

@jiazjun3069 2 жыл бұрын

Great sharing, Paulie! Thank you for bringing up this amazing solution! Alternatively, if let say I want to put up the PDF in Power BI, instead of Power Apps, can we do that?

@rodelski5514 2 жыл бұрын

great share and video. Just wondering since the flow trigger is "when a new file is added...", what if I have existing pdfs already uploaded to different subfolders in the Shared Documents. will this workflow still work? thanks in advance

@rodelski5514 2 жыл бұрын

also, Im very new with flow, any ideas on how to filter that this dataURI can only be applies to PDFs only? thanks in advance

@nooralkhawam4161 2 жыл бұрын

Amazing as usual. Can you please advise how to apply digital signature in the viewed pdf ?

@PFnism Жыл бұрын

How do you do it with 2 screens? 1 screen for the gallery of files and another screen for the pdf viewer?

@PaulieM Жыл бұрын

One is a gallery, one is the PDF viewer control.

@pmd7530 2 жыл бұрын

Hi Paulie. I've followed your guidance but the flow always fails with error message "File not found" which doesn't seem possible given that adding a file is what triggers the flow. Any ideas for how to resolve this please? I've tried a variety of tweaks all with the same result.

@viettuan174 Жыл бұрын

Hi Paulie, thanks so much for your video. I followed your instructions and made an app to upload and review pdf documents. However, when more files upload (21 files now with average 4mb each file), the app starts very low to load gallery of documents and then pdf viewer (4minutes). So does the size of the document library be the cause of the problem and how can I improve it? Thanks.

@TheAljwal100 Жыл бұрын

Thank you for this video tutorial, but I do not recommend this method, I have many pdf files and this causes a very slowdown in the application and the SharePoint library

@PaulieM 6 ай бұрын

It doesn’t slow the library at all if you hide the column.

@Addek 2 жыл бұрын

Hey Paulie, thank you for this really helpful Video. I wonder if you know, how to send these PDFs per email. And if you do so, could you show this in another Video?

@ahmadzabidi4497 2 жыл бұрын

Great video Paulie! i have a question if i can make the loading time for my gallery any faster because i have around 30 diffrent pdf in my sharepoint document list.

@SAULSM17 3 жыл бұрын

Gracias!

@riccol1972 3 жыл бұрын

Odd, when I view the content in the compose, I get the actual PDF displayed as output - not the content. I have the following in the dataURI field dataUri(base64ToBinary(base64(body('Get_file_content')))) and this works ?

@PaulieM 3 жыл бұрын

Strange, what browser is that in?

@riccol1972 3 жыл бұрын

@@PaulieM Chrome. Its working fine, have converted many PDFs

@rodelski5514 2 жыл бұрын

@@riccol1972hi im having the same issue. What was your solution/workaround? Thanks

@riccol1972 2 жыл бұрын

@@rodelski5514 It's been a while but I've just checked the flow and it still works as above. Move PDF into Temp doc lib and then convert to base64 in another list to display PDF directly in powerapp.

@rodelski5514 2 жыл бұрын

@@riccol1972 glad that your flow is still working. I'm sorry still don't understand this. any chance we can be on a zoom call or something? thanks

@itforeveryone5426 2 жыл бұрын

so good

@Makaveli198 2 жыл бұрын

Awesome video, ia m facing challenges with error " action in this flow may result in an infinite trigger loop" if you can help

@PaulieM 2 жыл бұрын

Are you creating a file in the document library from within the trigger?

@janelouise369 2 жыл бұрын

Hi Paulie I have implemented this successfully but when I load the selected gallery item into a collection and try to reference the URI from the collection it no longer works. any ideas?

@PaulieM 2 жыл бұрын

Hi Jane, it has been a while since I looked at this. I will try it again this evening and see if I can spot any potential pitfalls.

@gerardoramirez8252 2 жыл бұрын

Funciona perfectamente 18/10/2021, muchas gracias muy

@gerardoramirez8252 2 жыл бұрын

Hasta esta fecha es el mejor tutorial que he encontrado para poder visualizar los PDF

@greciamunoz600 2 жыл бұрын

@@gerardoramirez8252 ¿En tu caso la lista en donde se guardan los pdfs... tuviste que brindar alguna clase de permisos a los usuarios de la app para que pudieran visualizarlos?.... Saludos!

@SethBrauning Жыл бұрын

Hello Paulie, thank you very much for the great video! Really appreciate it. Is there a way to implement this without using the PowerApps gallery? In otherwards, have the PDF viewer open the file directly from the sharepoint Library by filename or ID and then use the dataURI for displaying the file contents?

@PaulieM Жыл бұрын

Yes, but you would need a collection of IDs from SharePoint, I don't remember what is in the video content but in my PDF viewer I used code like: LookUp(ERPDocs,ID = galMeta.Selected.SharePointID).dataURI) ERPDocs is the SP List, where ID is being used to lookup the record where it is equal to the ID in the selected gallery. So you would only need to replace: galMeta.Selected.SharePointID With your SharePoint ID and you'd be set.

@SethBrauning Жыл бұрын

@@PaulieM Thanks for the great answers. I think I found a way to make it work.

@XeniaD 6 ай бұрын

hi paul , hope you can see this message , this works but my team cannot see the documents bacause of JSON format

@PaulieM 6 ай бұрын

Why not? Just hide the json column from the view and your team will see the documents normally in the library or directly in the power app using the json.

@XeniaD 6 ай бұрын

Paulie , sorry . It says “ You cannot retrieve document , the response is not in JSON format “

@PaulieM 6 ай бұрын

@@XeniaD I’m not sure where you have gone wrong. You can get in touch with me via my blog and I can help you out.

@XeniaD 6 ай бұрын

@@PaulieM Thank you so much! it worked amazingly , QQ can i upload many documents at once or gradually? also i assume this method would work for any other type such as Word,PPT and excel right?

@PaulieM 6 ай бұрын

@@XeniaD it will only work with a PDF I’m afraid.

@mamacassi 2 жыл бұрын

This is a super easy way to do this - however my pdf's still dont show - is that because the library is shared to members of my environment/team ? I need to keep my documents secure and still have them viewable but Ive tried so many ways and it never works.

@greciamunoz600 2 жыл бұрын

Hi, i have the same issue... did you get a solution?

@mamacassi 2 жыл бұрын

@@greciamunoz600 I had to rollback to an earlier verison on power app. Tbey said it was a bug but would be getting fixed so dont know if its fixed yet. Perhaps try rolling back. I had to roll back 2 or 3 versions and that was 2 months ago.

@arjungoud3450 2 жыл бұрын

Somehow my page has crashed,

@AlQuLa 3 жыл бұрын

Could it be that since yesterday this is no longer supported by the pdf viewer?

@PaulieM 3 жыл бұрын

It’s the studio update today causing the problem. The PDF viewer does not work at all in the environments I’ve checked. But if you change the studio version it comes back to life.

@AlQuLa 3 жыл бұрын

@@PaulieM thanks for the answer! What do you mean with studio version?

@PaulieM 3 жыл бұрын

@@AlQuLa check this out: powermaverick.dev/2020/08/03/authoring-version-in-canvas-apps/

@AlQuLa 3 жыл бұрын

@@PaulieM Wow man, I've been figuring out why it didn't work for about 8 hours today... You are a lifesaver! I have only been working with powerapps for a few months but it's people like you who keep me going! Big thumbs up for you man, have the best weekend!!!

@PaulieM 3 жыл бұрын

@@AlQuLa Thank you 🙏

@julien8979 Жыл бұрын

Hello Paulie, thanks for sharing. Is this option available with Azure Blob instead of SharePoint and will make it work to display different types of documents using the PDF Viewer?

@Sunilprakashsabbithi Жыл бұрын

I followed your steps but i am always getting this error please let me know if there any solution. Invalid or corrupted PDF file. More Information Close ..PDF.js v2.14.305 (build: eaaa8b4ad) Message: Invalid PDF structure.

@kartikagarwal9339 5 күн бұрын

Is it possible for us to store this pdf file in dataverse table and load it from there instead of getting it from share point.

@PaulieM 5 күн бұрын

Yes, you can store it in a string column just like I did in SharePoint, just beware that base64 is very inefficient so you will use a lot of space storing PDFs in a short time.