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

Problem with drop down list

Hello community
I am embarking on the creation of Power apps and I already have a 1st problem.
I linked my form to an Excel workbook and a table named "TabSuiviDemandes"
I have one of the fields which must be filled with the selection of a drop-down list

 

 

DataSourceInfo([@TypeDélai]; DataSourceInfo.AllowedValues; "Type") 

 

 

This same list is linked to another table in the same workbook. Seems basic to me.
On the other hand, when I launch my app, it is impossible for me to use this drop-down list and I do not understand why
Do you have an idea with the little element that I can give you ?

 

Thanks

3 REPLIES 3
RandyHayes
Super User
Super User

@BrunoDu45 

You are stating that your datasources are all Excel. 

You mentioned your datasource table being TabSuiviDemandes, so what is TypeDélai?

 

At any rate, Excel does not have allowed values properties as it is considered just a table.

So, what are you trying to get values for?

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Hi Randy,

 

"TypeDelay" is another table in my workbook in another sheet named "Params"


What I want to do is be able to select one of the 3 values ​​from my "TypeDelay" table to be able to integrate it into my monitoring table.


Like data validation in Excel 😉

 

I'm a noob 😂

RandyHayes
Super User
Super User

@BrunoDu45 

No problem on the noob part!

So, your Dropdown list Items property should just be the name of that table then - TypeDelay.  As long as you have this as a datasource, you will get it in your dropdown.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,008)