You’re offline. This is a read only version of the page.
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.
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!
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
Share
Report
All responses (
Answers (
53
