Announcements
What's the meaning of "There are no tables in this file" ?
Hi Fanny,
To create an App from Excel Data, an Excel file with data should be formatted as a table, and then upload the file to a cloud-storage such as Dropbox, Google Drive, OneDrive or OneDrive for Business.
These two articles could be a reference for you:1.Create an App from Excel Datahttps://powerapps.microsoft.com/en-us/tutorials/get-started-create-from-data/2.Create an Excel table in a worksheethttps://support.office.com/en-us/article/Create-an-Excel-table-in-a-worksheet-E81AA349-B006-4F8A-9806-5AF9DF0AC664?ui=en-US&rs=en-US&ad=US
Please format your Excel file as a table and try again for this issue.
Best regards,Mabel Mao
Able to connect to the Excel now, but only limit to those Excel without formula. It seems not make sense. I believe all Excel should have formula....
I have seen a similar thread about “If Excel has a formula, data not showing”. In this thread, Staff CarlosFigueira said that tables in Excel with formulas are currently not supported.
The thread link is:https://powerusers.microsoft.com/t5/PowerApps-Forum/If-Excel-has-a-formula-data-not-showing/m-p/1539/highlight/true#M941
I would also suggest you submit an idea at “PowerApps Ideas”.
The link of the “PowerApps Ideas” is:https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
I have the same problem. I tried taking out all of the formulae but it's still not working.
I've even taken out the formating for percentages and dates, but still no dice.
Help!
i have an excel with a table defined. even after pulling the table, it says excel is corrupted, Why?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 330
Mohsin Ali 232
