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

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

13 hours ago

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

2 days ago

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

3 days ago

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

3 days ago

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

3 days ago

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

3 days ago

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

3 days ago

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

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