Unanswered

New App from Excel Spreadsheet in Onedrive for Business Shows None of the Data

(1) Share

Report

Posted on by seraph787

149

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

seraph 7 on at

Like
a
(0)

Report
Copy link

Link copied!

So I'm the only one with this issue? It's kind of show stopping. Can't do anything.

Was this reply helpful? Yes No
v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @seraph787，

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?

Regards,

Mona

Was this reply helpful? Yes No
seraph787 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mona,

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?

Thanks,
-S

Edit: Here's a link that I found in my email to the thread.

https://powerusers.microsoft.com/t5/General-Discussion/Sort-Gallery-by-One-of-Many-Dates-based-on-Priority-of-date-and/m-p/106839

It doesn't show the replies from others. I can't post in it because it says I don't have sufficient privileges.

Was this reply helpful? Yes No