Hello, I'm a beginner in Power Apps and I'm trying to use Excel as a data source to build my power apps gallery. This is the issue I'm facing -
I'm trying to connect my Power App (Gallery) to an excel file uploaded to the teams channel. It should ideally let me select the excel file and build an app based on the table present in the excel file. Instead, it further shows another drop down and says "this file doesnt seem to have any tables". Can someone please help me out? Thanks!
You need make the data into a Table, steps as below
Name
city
test
test
test
test
test
test
test
test
test
test
test
test
test
test
Let you have those data in excel, select those and go to Home tab there you see Format as Table
It will show you different colors to format, select one and it will prompt you the create table and range, select My table has Headers to make Name and City as Header
Once you click ok, then try it will show in you power apps
If I have answered your question, please mark it as the suggested answer. If you like my response, please give it a Like.
Regards,
Srini
Was this reply helpful?YesNo
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.