I have connected to my Onedrive for Business account to create a PowerApp based on an excel spreadsheet that's there. I am able to select the table that I have created. The table has headers, it's almost 100 rows, and just shy of 50 fields per row of data.
When it creates the app, it doesn't mention any issues, but the gallery that should be dislplaying all 80+ records is just blank.
I've tried reassigning different fields to each gallery record label. Nothing seems to work.
When I check the other pages of the rendered app, I notice that one of the other pages says that it's not connected to any data source, so I connect to the same worksheet. Each time I connect to the same worksheet, it shows as whatever the name is plus "_1" and "_2". So it seems like even when I connect them, it doesn't register that it's connected.
I'm at a loss for what's really going on here. Can someone help?
I just tested with an excel table in my OneDrive for Business and I cannot reproduce your issue in my PowerApps. All data shows correctly in my app. In that case, please provide more information about your app:
1. How did you create the app? From blank, or did you just use the OneDrive for Business connection and let PowerApps create the app automantically?
2. Is this only happening to this excel table? Would you please try to create a new app using another excel file from OneDrive for Business.
3. Did you have any special settings on the table?
I had formulas in my table. When I removed all formulas, I was able to see everything in the powerapps.
I'm now working on ways to replicate those formulas using functions within PowerApps, but yesterday when I tried to provide more information in another thread, my post wouldn't post. I tried editing my original post to include the additional info that someone asked me to provide. But that caused the entire thread to disappear.
It's frustrating. But perhaps you can help? Or at least help my thread to re-appear so that someone can help me?
Edit: Here's a link that I found in my email to the thread.
It doesn't show the replies from others. I can't post in it because it says I don't have sufficient privileges.
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!
Features releasing from April 2020 through September 2020