Drop down menu and library

(0) Share

Report

Posted on by Rubio_Damien

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 ?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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?

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

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"
2. Inside my app, I have a dropdown control called "Dropdown1":
3. Here is my Gallery, displays correct record based on selection in dropdown.
Best regards,
Allen
Rubio_Damien 61 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
Rubio_Damien 61 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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
Rubio_Damien 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer it's good now !