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!
I love this video and how you demonstrated an alternative to Reza's! I too am storing documents in sharepoint but I have data about each document in dataverse and an entry in the table contains a sharepoint link to the document relevant to that entry. I was wondering if I could use this hyperlink from dataverse instead of a flow directly connected to the sharepoint folder?
That is exactly what I do, when the document is created I store the ID of the document from the SharePoiint library in dataverse and then show it based on the selected Dataverse record.
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?
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
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?
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.
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?
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.
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
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.
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
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.
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...
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.
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?
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 ?
@@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
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
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 ?
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.
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.
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!
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.
I have used this method for a while and it worked well. but then it stopped showing the pdf in powerapps. After a lot of troubleshooting, it turned out that the amount of data was too large to get into powerapps, so I got an error message. The limit I have is 17 files. The problem is that every week there is a new pdf in sp.
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 ?
@@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.
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
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?
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'."
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?
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 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.
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.
@@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?
@@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!
Not sure what happend. It works for me for a long period of time but a few weeks a ago it did not work. I mean for my PowerApp pdf viewer cannot show pdf file from sharepoint.
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 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!!!
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
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.
