Unanswered

Can Not connect to data in Excel

(0) Share

Report

Posted on by JM-23071900-0 Microsoft Employee

My Excel data is formatted as a table. I have tried putting it on OneDrive, I have tried accessing data from SQL Server, and I have tried to import the data into a Common Data Service. Nothing seems to work. The App I intend to buidl is quite simple and will only read the data, which is only 42 records long with 15 columns. This shoudl be SUPER simple, but I have been unable to connect to it in any fashion.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

dansshin 53 on at

Like (0)

Report
Copy link

Link copied!

I know that Excel on OneDrive and Azure SQL works. Make sure that you are sharing the data with the people you are sharing the app with. For Excel you need to share it at the file name not folder level.

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jomors,

Please first take a check with the guide below:

Generate an app from Excel data

In order to take use of this Excel data, we need first create a connection, take OneDrive here for example, once the connection created, we need to naviagte to this Excel file, find the proper table and then connect to it.

If you have any further issues when working with it, please post back.

Regards

Was this reply helpful? Yes No
JM-23071900-0 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks for the responses! The comments encouraged me to dive back in over the weekend and I did manage to source the Excel from OneDrive. My original Excel was heavily formatted (thought it was in a Table). This seems to make things a bit funky in Excel (e.g. rename the table, but only the original table name is visible through PowerApps, and both names show up in Excel). I copy and pasted values only into a new worksheet, applied minimal formatting (e.g. currency values), and created a new table from the cleaned up data. Deleted the original worksheet. Seemed to do the trick and everything read in just fine. Have not tried importing into Common Data Service yet.

Thanks again!

Was this reply helpful? Yes No