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 / Drop dow list from exc...
Power Apps
Unanswered

Drop dow list from excel table

(0) ShareShare
ReportReport
Posted on by 8

Hi,

 

I am building a very simple app to make a healt questionnary, from a simple Excel table. Here is my problem. All of my cells in my table have a drop down list, except for the date.

I have connected both table (table1 = the data reccord where all the drop down list are, table_Liste = The drop down list source for all the drop down in table1)

When I swich the DataCardValue to make it a drop down list in the edition tab it does not show the list. It only make the switch to a drop down but with no choice.  It's like it won't connect to the data in my excel table.

When I change de the data source then it creates an error message for the DataCard  in the data section ; Update field.

 

I just can't figure it out, please help me 🙂

 

Thank you.

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Hi @Alleghanys 

    Since you are new to PowerApps, I suggest that you allow PowerApps to create your App from the datasource.  Starting in https://make.powerapps.com/  Select the option Excel on line and then follow the prompts.  PowerApps will create a three screen app from your data.  

  • Alleghanys Profile Picture
    8 on at

    Hi, 

    This is what I did... But then When I select the drop down filed in the control nothing works.

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Alleghanys 

    OK, I am not sure which screen and which control you are referring to.  Could you please post a screenshot of the screen containing the control and select the control and show its items property. 

  • Alleghanys Profile Picture
    8 on at

    I did It ! sometimes it's a good thing to be stubborn!

     

    Thank you for repplying. Have a great day

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
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard