How to upload files to SharePoint for Dataverse integration in a Power Apps canvas appp

Use Case
Recently, someone asked me if it was possible to utilize the SharePoint integration in Dataverse not only from a model-driven app, but also from a canvas app. Challenge accepted!
Tl;dr: yes, it is possible and it’s easier than you might think!
Some prep work
First, we will need to do some prep work.
- Setup SharePoint integration in Dataverse - here is a good blog post by Matthew Devaney that will guide you
- Make sure that the SharePoint folders that get created, do not append the record name of the Dataverse record with some GUID (Microsoft does that so that there are no duplicates, if you for example name the record like a customer and then have 5 customers with name
Miller
.) You can do this with an amazing tool by Sean McNellis, Shaun Wilkinson describes how to do this. - We will need the SiteId and DriveId of our SharePoint library. You can get those using Graph EXplorer
The canvas app
At a minimum, you will need to have 3 things
- a connector, that does the heavy lifting calling the right endpoint in the Graph API to upload a file to a specific folder - we will use the Office 365 Groups connector
- an attachment control (you get this from a form, connect this to a random SharePoint list, cut out the DatacardValue control, rename to Attachments and delete the rest of the form)
- a button that will take care of the action.
I also added a table/gallery so that I can choose the record to which I want to associate a file.
It looks like this:
Table/Gallery
- Add the Dataverse table to your app and connect your table/gallery to it
- Add the Office 365 Groups connector
- In the OnSelect of the table, put
Set(varDriveId, "<DriveId goes in here>");
Set(varSiteId, "<SiteID goes in here>");
Set(varFolder, Table1.Selected.Name)
Button
- Add a button
- Put in the OnSelect
ForAll(
Attachments.Attachments,
Office365Groups.HttpRequest(
"https://graph.microsoft.com/v1.0/sites/" & varSiteId & "/drives/" & varDriveId & "/root:/" & varFolder & "/" & ThisRecord.Name & ":/content",
"PUT",
ThisRecord.Value
)
);
Reset(Attachments);
This will upload all your files that you select with the Attachments control and to a folder that has the same Name like the associated record that we selected in the table/gallery. If the folder does not exist yet, it will be created, if it already exists, then the file will be only uploaded into the folder.
As a result, regardless if we use the canvas app or the model-driven app to upload files, they all get associated with the correct record in Dataverse"
If you’d like to know how to display previews from files on SharePoint in the canvas app, here is a neat blog post by Diana Birkelbach
Conclusion
Canvas app can work nicely in addition to a model driven app with SharePoint integration, powered by the Office 365 Groups connector. Let me know what you think!
Published on:
Learn moreRelated posts
Power Apps Pulse June 2025
Simplifying Copilot Chat in the Microsoft 365 Copilot app
Microsoft is simplifying Copilot Chat in the Microsoft 365 Copilot app for users without a Microsoft 365 Copilot license. Chat will now appear...
Microsoft Teams: Compact notification size for users
Microsoft Teams is introducing a compact toast notification size for Windows users, available from July 2025. Users can enable it via Settings...
Reminder: Updates to required permissions for Microsoft Graph Beta API deviceManagement
Starting July 31, 2025, certain Microsoft Graph Beta APIs will require either DeviceManagementScripts.Read.All or DeviceManagementScripts.Read...
Microsoft Copilot (Microsoft 365): Improved Python-powered answers in Copilot in Excel
Copilot in Excel now provides improved direct answers to your data analysis questions, using Python. Product Excel Release phase General Avail...
Microsoft Copilot (Microsoft 365): Researcher is in Microsoft Word
Researcher agent is now available in Microsoft Word, empowering you to tackle complex, multi-step research tasks with ease. Whether you’...
Microsoft Teams: SQL-like commands in the search bar
Efficiently narrow down your search results by using SQL-like commands in the search bar. Users can quickly filter messages, files, or convers...
🔓 Understanding the “Access app scope” Feature in Canvas App Components (Power Apps)
💡 Introduction In Power Apps Canvas Apps, components play a crucial role in building reusable UI and logic blocks. However, traditionally, co...
Microsoft 365 & Power Platform Call (Microsoft Speakers) – Community Takeover – July 1st, 2025 – Screenshot Summary
Call Highlights  SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...