Upload A File To SharePoint From PowerApps Using Flow

Ronika Jency

6y199.3k12100Article

12 Comments

Join the conversation! Your thoughts help the community grow.

Narsinga Rao4y ago
I'm new to power apps, There is one excel file in SP library, we want to update it through power app. is it possible?
Narsinga Rao4y ago
Getting error while writing this formula Savefile.Run(CreateFile_FileName - TextInput1.Text,CreateFile_FileContent - TextInput2.Text)
Eric J.5y ago
There no longer appears to be a Power Automate Template for uploading a file to SharePoint from Powerapps, and the Powerapps trigger will not create the correct input for the file contents. I only get one parameter in PowerApps, and I can create a file, but it has no contents.
Bhawan Das6y ago
How to upload an excel file in power app and then sort specific data according to given id and then export that specific data to new excel file to automate the manual workload.
Gloubiglouba Patatra6y ago
Cool ! Thanx for the article... I would like to add info to the file (let's say that the file need to be about 1, 2 or 3 different themes ... animals AND/OR fruits AND/OR vegetables). I know how to create checkboxes on the powerapp + I know how to create a new field (list of choices) in the SharePoint library BUT I have no clue how to report the data from the PowerApp into the SharePoint library field... Anyway you could help me ? (I am no developper and have very little skills... except writing if... then on a paper with a pen) That would be fabulous !
- Ronika Jency6y ago
  Hi Patatra, Thanks! you can refer the link - https://www.fidelityfactory.com/blog/2019/5/27/how-to-connect-to-sharepoint-online-document-libraries-using-powerapps-canvas-apps
Ashish Shukla7y ago
Can we get a link to uploaded file in powerapps after the document is uploaded?
- Ronika Jency7y ago
  Hi Ashish, you can get the URL of upload document in SP.still, many features are not support in related to file. Find below url for reference, https://powerusers.microsoft.com/t5/Flow-Ideas/Retrieve-URL-of-Doc-in-SP-Doc-library-in-order-to-add-the-URL-of/idi-p/36423 Https://flow.microsoft.com/en-us/blog/howto-upload-return-file/
Gladys Aguilera7y ago
What about uploading an image?
- Ronika Jency7y ago
  Gladys Aguilera - Hi, Please find the link - http://johnliu.net/blog/2019/4/flowninja-hack-87-lock-microsoft-flow-powerapps-trigger-to-upload-images-to-sharepoint-with-ease
Denis Molodtsov8y ago
Yes, selecting a local file is a capability missing from PowerApps. What a shame.
VamsiKrishna Batchu8y ago
How about selecting local file and upload? lets say i would ike to select video or document located in my phone to SharePoint library

Introduction

In this article, we are going to see how to upload a file to SharePoint from PowerApps. Refer to my previous article for creating a PowerApps application:

Introduction to PowerApps and Creating Template with it

Step 1

Create one new screen -> click Home -> select New Screen -> Screen Name(Screen -2)

Step 2

Create one new label -> click Insert and select label

Step 3

Selected label is shown in the below form. Label text name is changed under property control.

Step 4

Click Insert -> select Text Input -> Select Textbox for get file name from user.

Step 5

We can set a Textbox default value, I am leaving the default value is empty.

Step 6

Repeat steps 2 to 5 for placing the file content label and file content text box

Step 7

Click Insert -> choose Button

The button is placed in the form

Step 8

Change the button Name -> Properties -> Text

Step 9

In SharePoint create one document library

Step 10

Flow template created for uploading the file to SharePoint from PowerApps

Step 11

The flow connects to SharePoint, and click to continue

Step 12

Choose site collection

Step 13

Choose the document library from the site collection

Step 14

Click edit for integrating with PowerApps

After Edit, full details such as file name and content comes from PowerApps and gives flow name-> click save

Flow Name: My Flow uploads a file to SharePoint from PowerApps

Step 15

Integrate flow with PowerApps. There are two ways.

First Way

Comes to PowerApps Application Select Button -> Click Advanced -> on select event write below formula(code)

MyFlowUploadafiletoSharePointfromPowerApps.Run(TextInput2_1.Text,TextInput3.Text)
Second Way

Added flow to power apps button by clicking the flow