Super easy method to Display PDF Files Stored in SharePoint in Power Apps PDF Viewer
HTML-код
- Опубликовано: 20 июл 2021
- 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.com/2018/10/11/d...
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.buymeacoffee.com/paulie 
Хобби
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
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!
Thank you! I will keep going!
Muito bom Parabéns, vi vários vídeo e esse foi o melhor para gerar pdf.
Thank you! I had a big problem with download file content from sharepoint, your video help me a lot!
Thank you, thank you, thank you, your solution is the only thing that worked for me, I tried everything! Well done!
Fantastic tutorial, thank you. I've been working on this issue for months and your solutions works beautifully, thank you for sharing your knowledge.
Thank you for the kind feedback 👍🏻
Best solution yet! While I adore @RezaDorrani, this one simplifies, err, updates PDF viewer capabilities. Y'all are awesome! Thanks so much! ♥
Thank you Jack, appreciate it.
best solution, no buttons calling flows etc. Love it
Thank you Paul, your solution was really helpful even when I am starting with Power Automate and Power Apps. Appreciate it!
Thanks for feedback, glad it helped.
Thank you for this amazing solution. It will come extremely useful for me in a project I have been working on.
Really pleased to hear that. It works so well, I’m using it for a project I am building right now.
Hi Paulie, Thank you so much for that. A very simple way of producing the PDF.
You're very welcome!
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 :)
It’s a nice method. I have a new method I need to implement actually
It works perfectly, thank you very much for sharing!
Happy to hear! I love using this method.
This is a great tutorial... very smart way to execute this. Thanks so much.
Thanks - glad it helped you out
Nice work paul, works a treat
Saved the day my Friend
Cool solution, thanks for sharing
Thank you for the video. How big file can be stored in the sharepoint field? Is there a file size limitation?
So good, this is the easest I've found!! Thanks x 1000...0000
Thanks for the feedback, it really is an easy method. Glad it helped.
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?
Great and thank you for showing solution
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.
Amazing as usual. Can you please advise how to apply digital signature in the viewed pdf ?
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.
Another great learning video. :-)
Hello, amazing solution.
now, what if I need to filter the gallery based on a label text ou combox box selected value ?
Nice one Paul.
Wow! Works great 🎉🎉🎉
Amazing idea and super implementation. Thank you
Will the same approach work for other file formats?
Yes, for images etc this will work (but obviously not in the PDF viewer control)
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.
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
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?
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.
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
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
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?
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?
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.
@@PaulieM Thanks for the great answers. I think I found a way to make it work.
Gracias!
Great tutorial please it is possible to implemant the deleting ooperation
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 ?
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?
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...
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?
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?
Just change the view not to show the column containing the encoded document.
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?
@@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.
@@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
Funciona perfectamente 18/10/2021, muchas gracias muy
Hasta esta fecha es el mejor tutorial que he encontrado para poder visualizar los PDF
@@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!
so good
I'm not able to select dataURI any longer, any suggestion?
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 ?
Hi, did you figure this out ?
@@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
@@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
What about if I wanna use a sharepoint folder inside Documents, instead of a proper List?
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
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 ?
Strange, what browser is that in?
@@PaulieM Chrome. Its working fine, have converted many PDFs
@@riccol1972hi im having the same issue. What was your solution/workaround? Thanks
@@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.
@@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
Awesome video, ia m facing challenges with error " action in this flow may result in an infinite trigger loop" if you can help
Are you creating a file in the document library from within the trigger?
My inputs/outputs are not displayed under my compose. How do I get them to display.
What is the scenario for the files already existing on the library? please let me know the solution for this.
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.
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?
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.
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!
The PDF Viewer has the zoom function built right into it.
How do you do it with 2 screens? 1 screen for the gallery of files and another screen for the pdf viewer?
One is a gallery, one is the PDF viewer control.
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.
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.
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'."
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.
Hi, i have the same issue... did you get a solution?
@@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.
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?
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
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?
Hey Paul, does the image control require premium connector?
@@DeShonClark Yes - I will have another play this week and see if I can force something in! :D
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.
I’ve done it - will be posting info this week.
but why large number of pdf's are not loading in gallery
Could it be that since yesterday this is no longer supported by the pdf viewer?
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.
@@PaulieM thanks for the answer! What do you mean with studio version?
@@AlQuLa check this out:
powermaverick.dev/2020/08/03/authoring-version-in-canvas-apps/
@@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!!!
@@AlQuLa Thank you 🙏
hi paul , hope you can see this message , this works but my team cannot see the documents bacause of JSON format
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.
Paulie , sorry . It says “ You cannot retrieve document , the response is not in JSON format “
@@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.
@@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?
@@XeniaD it will only work with a PDF I’m afraid.
Somehow my page has crashed,
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
It doesn’t slow the library at all if you hide the column.
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.