Answered

PowerApp OneDrive Excel no data display

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Suddenly, the PowerApps does not display any data in a gallery. A simple query like countrows(table) also return zero data. Checked the Excel file and no missing data.

Session ID: a2780286-5f89-48c3-94f5-ac4adf815de3
PowerApps 3.18114.24

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

xyzzyx666 170 on at

Like (0)

Report
Copy link

Link copied!

Hi
Firstly,do you format it as Table?
Scondly,do you use the gateway?make sure it connect your table ok.
Thirdly,if everything is ok,you can try to view->datasource->data->choose the table remove and then add datasource to try it again.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

I have made a test on my side, and don't have the issue that you mentioned.

Please check if you have format your Excel file data as a Table on your side.

Please also check if the connection to the Excel table within your app is invalid. Please consider remove the connection from your app, and then re-add a new connection to your Excel table, then check if the data is displayed well within your app.

In addition, please also take a try to clear cache of your browser, then check if the issue still exists.

If the issue still exists, please consider submit an assisted support ticket through the following link:

https://powerapps.microsoft.com/en-us/support/pro/

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, I have rebuild the spreadsheet and it works fine now - Regards

Was this reply helpful? Yes No
FedexT 8 on at

Like (3)

Report
Copy link

Link copied!

Had the same problem. The app worked if I used a normal Excel file (desktop) but it didn't if I used the exact same file uploaded on OneDrive for Business.

I've found out that formulas are the "problem". If you take away the formulas from your tables (and recreate them using formulas on PowerApps), PowerApps shows the data correctly.

Don't know why and it is probably not the easiest but it works.

Was this reply helpful? Yes No
7700 24 on at

Like (11)

Report
Copy link

Link copied!

Hey everyone, just wanted to add to this, if you run into this problem also check if you have the XLSX file open on either Excel Online or locally. I was facing this exact same issue, then closed the file on my computer, refreshed the data source and voilá!

Was this reply helpful? Yes No
chandanrateria 17 on at

Like (7)

Report
Copy link

Link copied!

Hi ,
I was facing the same issue
Powerapps was not able to fetch the data from Onedrive (Excel)
Then i tried closing the file which i kept open online
Voila! It worked
I spent 4 hours looking for a solution to this.
Thank you for your valuable feedback

Was this reply helpful? Yes No
EmilyLouise 4 on at

Like (0)

Report
Copy link

Link copied!

THANK YOU

Was this reply helpful? Yes No
wadepooja 8 on at

Like (3)

Report
Copy link

Link copied!

Another potential reason could be that the file is open in one drive. When the file is open, you cannot access data in Power App.

Was this reply helpful? Yes No
CayoSonia 18 on at

Like (3)

Report
Copy link

Link copied!

Couple of other things.
Make sure your excel sheet isn't open - PowerApps sometimes struggles with this
Make sure you have a column at the end of your table called __PowerAppsId__
If you need to add the column to your table, save and close excel and then refresh your data source in powerapps

Was this reply helpful? Yes No
FarooqueShaikh 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks

Was this reply helpful? Yes No