Connecting Sharepoint document to power APP

(0) Share

Report

Posted on by ES-10022213-0

Hello,

I uploaded an Excel file to SharePoint (under My Documents) and added it as a data source in my Power Apps app. The Excel file contains a formatted Table.

I created a new screen to display and/or export the table data, but the screen is blank.

Could you please explain the correct way to retrieve data from an Excel table stored in SharePoint using Power Apps?

Do I need to convert the data into a SharePoint list, or is it supported to work directly with the Excel file?

Thanks in advance for your help.

Categories:

Connector development

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ES-10022213-0,

I will answer this in two parts - firstly if you have connected the Excel table as a Data Source in your app, then accessing it is no different to any other Data Source. You firstly need a gallery with the Table as the Items and then Text Labels with (using your field names) ThisItem.YourFieldName. You can then create a form to edit/create/view the records. This tutorial may be of assistance.

However Excel is really the "data source of last resort" and has many limitations. If you have access to SharePoint Lists, I suggest you put the data in one of those.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

Inogic 1,291 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Step 1: Create a SharePoint List from Excel

Open your SharePoint site.

Go to Site Contents.

Click New → Select List.

Choose From Excel.

Upload the Excel file.

Select the table inside the file.

Review and adjust the column types if necessary.

Click Create.

Step 2: Create a Canvas App Connected to the SharePoint List

Go to Power Apps.

Click Create → Select Canvas app.

Choose the layout (Phone or Tablet).

Select the newly created SharePoint List.

Step 3: Display Data in a Gallery

Insert a Gallery (Vertical gallery recommended).

Select the Gallery control.

Set the Items property to:

YourListName

Select the fields you want to display from the right-side panel.

The data from the SharePoint List will now be displayed in the app.

Hope this helps.

Thanks!

Inogic

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ES-10022213-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

Assisted by AI

Bitcot Automations 23 on at

Like
a
(0)

Report
Copy link

Link copied!
Here is a simple step-by-step guide to connect a SharePoint Document Library to Power Apps.

1. Create or Prepare a SharePoint Document Library

Go to your SharePoint site (for example your team site).

Click Site Contents.

Click New → Document Library.

Give it a name (example: ProjectDocuments).

Upload a few test files if needed.

This library will store the documents that Power Apps will access.

2. Open Power Apps

Go to Microsoft Power Apps.

Click Create.

Choose:

Canvas App (most common), or

Start from blank.

3. Add SharePoint as a Data Source

In Power Apps Studio open your app.

In the left panel click Data (database icon).

Click Add data.

Search for Microsoft SharePoint.

Sign in if prompted.

Select your SharePoint site.

Choose the Document Library you created.

Click Connect.

Now Power Apps can read files from SharePoint.

4. Display Documents in Power Apps

Insert a Gallery:

Insert → Gallery → Vertical gallery.

Set the Items property

In the gallery show fields like:

ThisItem.Name

ThisItem.'Link to item'

ThisItem.Created

5. Open or Download the File

Add a button or icon inside the gallery.

OnSelect property

Launch(ThisItem.'Link to item')

This will open the document stored in SharePoint.

6. Upload Files from Power Apps

Insert Attachments Control or Add Picture.

Use a Form connected to the Document Library.

Steps:

Insert → Edit Form

DataSource = ProjectDocuments

Add Attachments field

Add a Submit Button

SubmitForm(Form1)

Files will upload to SharePoint.

7. Filter or Search Documents (Optional)

Example search box:

Filter(ProjectDocuments, StartsWith(Name, TextInput1.Text))

8. Permissions Check

Make sure users:

Have access to the SharePoint site

Have permission to the Document Library

Otherwise files will not appear.

Was this reply helpful? Yes No