adding Excel file in a sharePoint Library to power App as data source?

(1) Share

Report

Posted on by SA-24081236-0

Why Power App does not show excel files stored in a SharePoint library as data source for app to be created? he only does so for lists in SharePoint site?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report

Hi

You should be able to choose the Excel file and the required Sheet as data source in Power Apps by using the "Excel Online (Business)" connector. Select this, your site and the required file.

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
schithambaran 138 on at

Like (1)

Report

Hi Nandit

Good Day!!

I have gone through your below reply dated 25th August. Thank you so much.

But as per my understanding these excel templates shall be standard table format. Any possibility to use the template (refer the below snapshot) and extract the data to SP List/ SP Document library ??

Best Regarsds

Sanil Chithambran

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report

Hi Sanil,

You are right. For unstructured data, I would suggest using Power Automate AI Builder - Document Processing model. Bear in mind that this is a Premium feature which means you will require a Power Automate Premium license to use it. It is $15 per month but you can start a free 30-day trial to explore the capability.

Here's a video tutorial for document processing by Dhruvin Shah, an MVP -

https://www.youtube.com/watch?v=Nrq4PDOfxHU

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No