cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Populate a selected column in excel

Hello,

I created a drop down list using items. Now I want to populate data in one column in the excel table. How can I do that?

 

Another problems is I started to see this problem "data type unsupported for evaluation"  and "this data use scope" I have never see this before when I created simple apps. Now when I build an app from the same data I see this error? How can I solve this?

Regards,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Populate a selected column in excel

Try this:
1. Change the textbox to text if it is number

2. What is the name of your table in excel

3. Did you try column by column as i sugested, did you see any difference

View solution in original post

5 REPLIES 5
Highlighted
Community Champion
Community Champion

Re: Populate a selected column in excel

1. If the name of your table is Table1, put this on the Items property of the Dropdown:
Table1.ColumnName

2. On the error, its better you show a screenshot

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Highlighted
New Member

Re: Populate a selected column in excel

I started to see this error.Before this was working.

Highlighted
Community Champion
Community Champion

Re: Populate a selected column in excel

What are the data types for "AY", "Gramaj", "Marka", are they string or number Columns. You can also reduce it to one after the other to identify which column is causing the problem example use only "AY", then change to "Gramaj"

 

Also how many rows are you dealing with for delegation purpose.

 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Highlighted
New Member

Re: Populate a selected column in excel

The data come from an excel file. All of columns are string. The point is that I used the same data to build an app and it was working good. When I tried to make a new one from this data where this error may possibly come, it also showed this error. Did I miss something here?

Regards,

Highlighted
Community Champion
Community Champion

Re: Populate a selected column in excel

Try this:
1. Change the textbox to text if it is number

2. What is the name of your table in excel

3. Did you try column by column as i sugested, did you see any difference

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,493)