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
Deprecation of MS-APP-ACTS-AS header in Shifts Management Microsoft Graph APIs
In app-only access scenarios, Shifts Management Graph APIs previously required the MS-APP-ACTS-AS: userId header to indicate the user on whose...
Microsoft 365 Copilot Services Outsourcing: Smartest Move for Business Growth!
In an era where AI is reshaping how businesses operate, the race to adopt the latest technologies is intensifying. One of the most exciting de...
Microsoft Defender for Office 365: AI-powered submissions response for improved result explainability
Microsoft Defender for Office 365 is introducing AI-powered explanations for email submission results, enhancing clarity on why messages are c...
Microsoft Teams: Presenters can promote attendees to the green room
Presenters in Microsoft Teams can now promote attendees from the waiting room to the green room using the Participants roster. This update is ...
Microsoft SharePoint: Header and Footer enhancements
Microsoft SharePoint is updating site headers and footers for a more modern, customizable experience, starting in July 2025. Enhancements incl...
Microsoft Teams admin center: Apply only configured settings from configuration profiles for Teams Android devices
Admins will have more granular control over configuration profiles for Teams Android devices, applying only explicitly configured settings and...
Microsoft Teams: In-app survey feedback policies will be managed by default with Microsoft 365 Cloud Policy
Microsoft Teams in-app survey feedback policies will be managed by Microsoft 365 Cloud Policy by default, starting late June 2025. This change...
Microsoft Teams: New feature suggests contacts for call transfers on Teams Phone devices
Microsoft Teams is introducing intelligent suggestions for call transfers on Teams Phone devices to streamline the process. This feature will ...