Loading...

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

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.

  1. Setup SharePoint integration in Dataverse - here is a good blog post by Matthew Devaney that will guide you
  2. 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.
  3. 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

  1. 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
  2. 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)
  3. 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:

canvas app

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"

folders in the SharePoint library

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 more
Luise Freese: Consultant & MVP
Luise Freese: Consultant & MVP

Recent content on Luise Freese: Consultant & MVP

Share post:

Related posts

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...

18 hours ago

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...

18 hours ago

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...

18 hours ago

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...

18 hours ago

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’...

18 hours ago

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...

18 hours ago

🔓 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...

21 hours ago

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...

1 day ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy