cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Cannot view correct data (string type) imported from excel in OneDrive for business

Hi,

 

SITUATION

I could import my data in table(.xlsx) from One Drive Business connector into my powerapp app. 

 

PROBLEM

However, when I select a field in my table for a dropdown, it shows me all 0 entries when it should show me strings like for eg. (MIT,CMU).

I checked my table (.xlsx) , it does show all the entries.

 

MY FIXES:

Tried on OneDrive Business, DropBox but got the same problem.

Tried on an excel file, static source for the app and got the correct strings (for eg. MIT,CMU) .

 Checked if my logged-in account & connector match (OneDrive Business) so didn't get any problem in reteiving the table on powerapp.

 

Any help is really appreciated.

 

Thanking in advance. 

1 REPLY 1
Community Support Team
Community Support Team

Re: Cannot view correct data (string type) imported from excel in OneDrive for business

Hi @Anonymous,

Do you want to view data imported from excel in OneDrive for business by using a drop down control?

There are some points that I recommend you checking:

  1. Have you formatted your table in one drive for business?
  2. Have you got data from your connection?

You can check it by creating a data table, setting its items:the data source that you’ve connected to.

 

 

 

If the points mentioned above aren’t suitable for you,please show me more details about it like pictures,formulas,etc.

 

 

 

Best regards,

Community Support Team _ Phoebe Liu

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (4,743)