cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jomors
Microsoft
Microsoft

Can Not connect to data in Excel

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.

3 REPLIES 3
dansshin
Advocate IV
Advocate IV

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.

v-micsh-msft
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jomors
Microsoft
Microsoft

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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,041)