cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rubio_Damien
Helper I
Helper I

Drop down menu and library

Hi everyone,

 

I encounter a problem bur i don't know where is it !

I have create a xls library and from this list i want to have a drop down menu.

For the box name ddledu2 i have set this code :

Distinct(nametable;'column')

And for the library :

Filter(nametable; column=ddledu2.selected.result) but there is nothing in result, could you help me ?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Rubio_Damien,

Seems your column name is "EDU_1", try to remove '' outside your column name, just directly use this column in the formula, so try this formula:

Filter(LAD_1; EDU_1=ddledu2.Selected.Result)

 

If still not work, provide the screenshot of this column type from your SharePoint list(Is this a Text column?).

Best regards,

Allen

 

View solution in original post

6 REPLIES 6
v-albai-msft
Community Support
Community Support

Hi @Rubio_Damien ,

Could you provide more information(better with screenshots) about below questions for helping us better understand your issue?

1. Can your dropdown shows selections correctly?

2. What's the column type of your column using inside your code? Is it a Text column? 

 

v-albai-msft_3-1620785073011.png

3. What do you mean "library" in below picture? A SharePoint library? Or is it just a Gallery inside your app?

v-albai-msft_0-1620784578493.png

 

I done a test on my side with your code, everything works fine. You can compare with my steps and check if there is any difference:

1. My list called "list10" with a Text column called "Letter_B"

v-albai-msft_2-1620784979121.png

2. Inside my app, I have a dropdown control called "Dropdown1":

v-albai-msft_4-1620785161249.png

3. Here is my Gallery, displays correct record based on selection in dropdown.

v-albai-msft_5-1620785191169.png

Best regards,

Allen

@v-albai-msft @Yes i don't understand. Attach  a  capture with the error message. Like you could see i take the value for the drop down menu the problem come from the gallery or the file i don't know

Hi @Rubio_Damien ,

Sorry I cannot understand the error message(it is not my language).

Could you please type the error message here so that I can translate it.

Best regards,

Allen

@v-albai-msft @L'opération demandée n'est pas valide

Reponse du serveur : échec de LAD_1 : !CKlxd!Syntaxe error at position 5 in 'EDU 1 eq 'I".Ploc! Inner exception : !CKlxd!Syntaxe error at position 5 in 'EDU 1eq 'I". Ploc! ClientRequestld : 3a1560b9-8368-425b-b8cd-1a19246f218f

Hi @Rubio_Damien,

Seems your column name is "EDU_1", try to remove '' outside your column name, just directly use this column in the formula, so try this formula:

Filter(LAD_1; EDU_1=ddledu2.Selected.Result)

 

If still not work, provide the screenshot of this column type from your SharePoint list(Is this a Text column?).

Best regards,

Allen

 

View solution in original post

Thanks for your answer it's good now !

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,546)