Show PDF files from SharePoint in PowerApps
HTML-код
- Опубликовано: 1 окт 2024
- In this video, I have created a PowerApp to Show PDF files from SharePoint with the help of PowerAutomate and ensured the data is rendering without any issues irrespective of the content in the file. This is the best video for Power App beginners to implement without any technical challenges.
You will learn:
1. How to use JSON function in Power Apps
2. Calling a Power Automate from Power Apps
3. Sending the data from Power Automate to Power Apps
4. Using Gallery in Power Apps
Substitute Function :
• Search & Find Function...
works like charm
I am happy it worked for you!
Very Helpful Khrishna and just what I am looking for on my project at the moment.
I am really happy this video is helpful to you at your work!
Thanks you very much sir its really helpful 🙏🏼 do u have any idea how to en large(fullscreen) the pdf with button ?
So If I get you right you want to make the PDF viewer window large is that right? if so do this:
Add a button with the title as Large: onSelect property of the button use the below code:
UpdateContext({varWidth:App.Width,varHeight:App.Height});
this will make the PDF viewer
Add another button with the title Small:
UpdateContext({varWidth:400,varHeight:150});
Assign these variables on the width and height of the PDF viewer control
Hello excellent. Keep going !! I was looking for this long time ago and your solution is quite clever and useful.
I am really glad I was able to takeout your long time pain...
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?
Great video! I wanted to do it this way as then I don't have to deal with PDF permission problems
Glad it was helpful!
Hi! just a quick question, Where did you get the varPDF ? im not getting this to work.
This should work may I know what is the exact error you see?
Hi Krishna, thank for you video. I am getting the error of "invalid number of arguments: received 2, expected 3", and it looks like my function is asking for an "InitializeVariable_Value" in addition to VarSiteAddress_Value and VarFilePath_Value. Do you know what might be the issue?
UpdateContext({varPDF:RenderPDFFileData.Run(Substitute(Substitute(BrowseGallery2.Selected.SDS,"%20"," "),BrowseGallery2.Selected.'Full Path',Blank()),BrowseGallery2.Selected.'Full Path')})
Not sure what is the issue, I need to check the app and code.
Please submit a ticket for a specific / your project related questions in powerusers.Microsoft.com for instant help. I am currently fully occupied with some personal and office work. I also come and help people in community as and when I get time. All the best!!
Now this flow method is not working...plz tell any other method
What is the issue you see?
@@krishnavandanapu-mvp9302 bro your contact number plz..?
Hi krishna garu, in my requirement I have to show all type document they can attach any type of file, if it is doc file means how could I show.Pdf viewer show only pdf file. Could you help in this, thank you ,thank's for great video
You can always validate the file type before you send the file stream to PDF viewer. Hope that answered your question.
Hi Krisha, I need your helps at the minutes of 11:03. At my end, I’m having an issue when trying to add the formula of varPDF.pdfcontent . It showing a red line. Any idea to solve it?
varPDF is a variable I am creating to hold the return value of the flow. So, ensure that it is created on your side. Watch the video one more time and ensure all the steps are followed as advised in the video.
When performing the lookup within the input box, 'Link to item' is not appearing. 'Link' is the only option that displays the full https url. I got it working, however do you have any ideas on why Link to item isnt showing up?
Not sure what you mean by Link to item, could you point me to the time I have explained in the video to help you better.
Hi Krishna, I am creating an app using this to show pdf's but I want to use it for multiple pages for different data sources, when I type in the formula for the selection icon on the vertical gallery its coming up with an error the second time i have tried to use it. The first page and vertical gallery it worked fine. See 2 codes below: first one worked, second one didnt.
UpdateContext({varPDF:RenderPDFFileData.Run(Substitute(Substitute(gal_AdvantEDGE.Selected.'Link to item',"%20"," "),gal_AdvantEDGE.Selected.'Full Path',Blank()),gal_AdvantEDGE.Selected.'Full Path')})
UpdateContext({varPDF:RenderPDFFileDataEpitaph.Run(Substitute(Substitute(gal_Epitaph.Selected.'Link to item',"%20"," "),gal_Epitaph.Selected.'Full Path',Blank()),gal_Epitaph.Selected.'Full Path')})
I need to check the flow and app to help you on this!
Nice video, thanks. I don't see the "DocType" option when I go to filter the Document Library to show just pdf... Do you know is there something I'm missing?
may I know where do you want and your scenario to help better
HI Krishna, Great Video.
I implemented the same in my application and working fine. But need small requirement like when ever you are selecting one file to another file in the gallary and size of the file is large it is taking sometime to load. So, I want to hide the PDF viewer control while the other document is loading or clear the content of pdf viewer till the other selected document is loaded.
Thanks.
You can certainly do it by adding the below line in NextArrow onselect property before you call the Flow
Set(ViewPDF,Blank())
this will clear the PDF vairable and on PDF control Visible property write the below formula:
!IsBlank(ViewPDF)
this will hide the PDF viewer control hide, hope this helps
Hi Krishna.... Got the chance to watch the video and it is truly great, thanks. Now I have a small query for you, can we edit the pdf file which is opened in pdf viewer and if so how can it be saved to a specific path?
No you can’t do it in PowerApps because it is only for view
Great Video to share with us Krishna! I am unable to find "DocType" function at the 2:00 mark, has it been discontinued?
In that Filter Doctype is not a function it is a column in my library. Hope this helps
my flow in the automate runs successfully, but the screen is gray instead of displaying the PDF
Watch the video one more time implement step by step this is a proven solution by many many people so it should work!
Hello Khrishna,
This video is amazing. How to convert SharePoint list item attachments into one pdf.
Yes create a gallery for the list you want and send the ThisItem.Attachment to the flow that will also work
Hi Krishna, really well explained your video, but even when I followed step by step the flow creation, it doesn't work for me. I suspect about the use of accent in vowels (spanish language). Do You think it could be the problem the flow has? if so, Could You help me with this topic, please. Thank you for your knowledge!
May I know what is the issue you see? I was able to get all the non English text.
Great video Krishna, thank-you for putting this together. I've had this working in a solution I built since March, but in the last few days it's stopped working, no errors, the pdf just doesn't render 🙁. I'll DM you on Twitter to see if we can hook up.
Thank you for your update yes this is the issue with new maker portal version: here is the community thread on the same
powerusers.microsoft.com/t5/Building-Power-Apps/PDF-viewer-stop-working/td-p/1250034
Thank you!! For me it works in chrome, but not in Explorer. Any ideas on how I can fix it?
Sorry, I typed Explorer, I meant Edge. It doesn't work in Edge for me.
It should irrespective of browser May I know what is the issue you are experiencing?
thank you very much!
This is master piece. Thanks!
I am glad you liked it.
Hi Krishna, nice video. I did not get it to work on my side as yet, the flow fails in the 4th step, and returns response is not in JSON format
Please go ahead and share me the error so that I can help you
@@krishnavandanapu-mvp9302 i have the same problem please help us... thanks
Please go ahead and share me the error so that I can help you
Hello Krishna, nice video!
I followed all your steps but and the end, in the OnSelected of the NextArrow, I put my variables but I got an Error saying "Invalid number of arguments: 2 received but 3 expected"
Hi Danny I am not quite sure…. Where you see this issue ? Share some more details
@@krishnavandanapu-mvp9302 No worries man, I found a solution. You can check it on my profile.
I learned watching your videos, thank you.
Please I have same issue. The next arrow is bringing up the error “Invalid number of arguments: received 2, expected 3” after inputting the formula
Please submit a ticket for a specific / your project related questions in powerusers.Microsoft.com for instant help. I am currently fully occupied with some personal and office work. I also come and help people in community as and when I get time. All the best!!
You save my life
This worked great thank you. A little slow to load but it works ;)
I am glad it is working for you!
Is there a way to see pdf with multiple pages by storing in Dataverse ?
this approach shows all the pages in the PDF irrespective of the data source.
@@krishnavandanapu-mvp9302 thank you will try this approach, is there a way we can upload multiple documents from Power Automate desktop to Data Verse ?
Not quite sure please post this question on community
HTTPS://powerusers.Microsoft.com
How to do this for power portal?
Good ask never tried this for portal.. I am not sure either …
Thank you very much!
you are always welcome I am happy it helped you...
Can we use onedrive instead of share point?
Yes you can use
@@krishnavandanapu-mvp9302 please tell me the process
I am not quite sure about needs share your requirements I will try to help you as per my availability!
@@krishnavandanapu-mvp9302 kk. Tq krishna
Did this just stop work last friday?
Nope it is still good what went wrong on your side ? Let me know the error I can help you!
@@krishnavandanapu-mvp9302 Hi Krishna, same issue here. Just stopped working all of a sudden. Flow runs successfully, no errors in the app itself. After selecting the PDF, the PDF viewer just stays blank.
If I edit or put a new version it will stop working,
now its showing a grey screen in the PDF control
This is because of new version of maker portal, Check this post friends:
powerusers.microsoft.com/t5/Building-Power-Apps/PDF-viewer-stop-working/td-p/1250034
Super work
Thank you