Upload files to Dataverse from Power Apps | Patch multiple files | File Column tutorial

In this Power Apps tutorial video, you will learn about uploading files into Dataverse from Power Apps. We will be working with the Dataverse File Column, leverage the Patch function to patch attachments to Dataverse File Column, upload multiple files using a related Table with File column, Download Dataverse file attachments, download Dataverse files, view attached files using PDF viewer, delete & add files.
File columns store binary data. File columns may be in any custom or customizable Dataverse table.
Patch allows us to insert or update one or more records in a data source, or merge records outside of a data source.
Video will also showcase how to work with the form control experience in Power Apps to upload files thanks to the Attachments control.

Helpful Links 🔗:
Dataverse file columns

Use Dataverse file column data

#PowerApps #Dataverse #PowerPlatform #Patch #File

Table of Contents:
00:00 - Introduction to Patch (Upload files) to Dataverse from Power Apps
00:32 - Dataverse File Column Type
02:02 - Model-driven Power App - Working with the file column (Upload file)
03:56 - Canvas Power Apps - Upload file with Attachments control inside Form Control
06:36 - PowerApps Patch function to upload attachment to Dataverse file column
09:38 - Upload multiple files to Dataverse Related Table (File Column) from Power Apps
17:52 - Delete files from Dataverse Table using Power Apps
20:00 - View Dataverse files (PDF) in Power Apps with PDF Viewer Control
20:47 - Subscribe to Reza Dorrani channel

🤝 Let’s connect on social:

[dougydoe]

This is brilliant, Reza, especially the multiple file uploads. Thanks for sharing. I'll definitely play around and experiment with this soon.

[arvindbhat]

Lovely to see someone who had a possibly humble beginning in Rizvi make such rapid strides internationally! Canvas apps would have been lot tougher without you. Keep doing great work!

[busyshah]

Bro, you are the best out of all the content available out there.
What I like the most is that (90% of times) you already have a video on something we are struggling with no matter how strange the problem is.

[madhuradamle]

Great video as usual, Reza! Thank you for sharing your knowledge in the simplest way possible!

[magepa]

I was looking for a way to load multiple files in Dataverse and your solution is brilliant!!! Thanks Reza

[SIDDHIRACEROGERS]

You are an absolute legend Reza. Thank you!

[kireetiyakkali]

Thanks a lot Reza! Great explanation as always.

[ronn_zw]

As always, thank you so much for sharing.

[oluwatobipaul]

Thanks so much Reza. I learnt a lot from the multiple file upload.

[yehunlavolontededieu]

Click - oh the wrong door...Sorry I will come back when when i work for an org who wants/afford data verse 😊...so far we good with mama SP. Thanks Reza for the quick review of the video that you give us it helps a lot to take a glance of the outcome ....

[stephendemanovich]

Thank you Reza for yet another outstanding video. You have a solution for pretty much everything I encounter and I appreciate what you do!

[vikramsingh-ylrl]

Thank you Reza for Great explanation....

[munyivangea]

Thanks for this, this sorted my edit issue.

[SauloOliveira]

I'm going to use this multiple attachments strategy in my project. Thank you Reza

[steventhawe]

Good content as always Reza, Quick question, i always use the attachments feature by enabling attachments on a Dataverse table and all files are stored as notes. What is the advantage of defining the attachments the way you have demonstrated here as opposed to the way I manage attachments?

[karukarthi]

Thanks for sharing, Reza. Really insightful. The same patch functions can be leveraged to store attachments in the list item with SharePoint as a Data Source?

[barnaliroy]

Very helpful! but is there any way to save multiple docs through OnSelect of a button instead of using EditForm?

[alexsegal]

Thank you @RezaDorrani - great resources. Question about the dataverse - how do we remove a lookup column? I cannot seem to find the way because of all the dependencies created due to the relations added. Thanks in advance!

[nebeir]

Hello Reza, great video, thanks 🤩
I see that the PDFViewer component has always been in "experimental" for many months, can we trust it to use it in a production environment?
Among other things, starting today in various tenants I'm experiencing extreme slowness in viewing documents, but in this case the datasource is SharePoint and not the Dataverse.🤕

[sakshisachdeva]

Hi Reza,
Thank you for all the video's, they are very informative and easy to follow. My question is regarding Microsoft forms. Is it possible to fetch total score from Microsoft forms and display it in a Microsoft list? OR through any means can the score be fetched from Microsoft forms and displayed somewhere.