web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Populate a selected co...
Power Apps
Answered

Populate a selected column in excel

(0) ShareShare
ReportReport
Posted on by 4

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,

Categories:
  • eka24 Profile Picture
    20,925 on at

    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.

  • mamadov93 Profile Picture
    4 on at

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

    Screenshot (2).png
  • eka24 Profile Picture
    20,925 on at

    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.

  • mamadov93 Profile Picture
    4 on at

    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,

  • Verified answer
    eka24 Profile Picture
    20,925 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard