Dynamique filter on dropdown

%3CLINGO-SUB%20id%3D%22lingo-sub-1865920%22%20slang%3D%22fr-FR%22%3EDynamic%20filter%20on%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865920%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20Everybody%2C%3C%2FP%3E%3CP%3EI%20have%20a%20question%3A%20i'm%20developing%20a%20small%20interface%20using%20powerapps.%3C%2FP%3E%3CP%3ETo%20store%20data%2C%20i%20use%20a%20sharepoint%20list.%3C%2FP%3E%3CP%3EI%20create%20a%20form%20to%20follow%20history%20of%20data%20added%20to%20sharepoint%20list.%3C%2FP%3E%3CP%3EOn%20this%20form%2C%20i%20want%20to%20create%20a%20dynamic%20search%3A%20i%20explain.%3C%2FP%3E%3CP%3EFirst%2C%20i%20create%20a%20dropdown%20list%3A%20on%20this%20list%20i%20set%20some%20column%20names%20from%20my%20sharepoint%20list%3A%20e.g.%20Author%2C%20Status%2C%20Country%2C%20etc.%3C%2FP%3E%3CP%3EOn%20a%20second%20dropdown%20I%20want%20to%20see%20distinct%20element%20based%20on%20column%20choose%20previously.%3C%2FP%3E%3CP%3EEx%3A%20in%20dropdown1%2C%20i%20select%20Author%2C%20so%2C%20second%20dropdown%20list%20must%20show%20separate%20author%20who%20add%20information%20to%20my%20sharepoint%20list.%20For%20example%3A%20i%20can%20see%3A%20Robert%2C%20Ed%2C%20Toto.%3C%2FP%3E%3CP%3EIf%20i%20select%20one%20Author%20on%20this%20dropdown%20list%2C%20now%2C%20in%20my%20gallery%2C%20I%20want%20to%20see%20all%20lines%20added%20to%20sharepoint%20per%20'Robert'%20for%20example.%3C%2FP%3E%3CP%3EThe%20problem%3A%20on%20dropdown%20list%3A%20i%20set%20column%20manually%2C%20but%20on%20second%20drop%20down%20dropdown2%2C%20powerapps%20do%20not%20understand%20column%20name%20as%20param%3AI%20set%20on%20Items%3A%20separate%20(Sharepointlist%3B%20dropdown1.selectedText.value).%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20solution%20please%3F%20Thank%20You.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1865920%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3Epowerapps%20dropdown%20list%20gallery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello Everybody,

I have a question : i'm developping a small interface using powerapps.

To store data, i use a sharepoint list.

I create a form to follow history of data added to sharepoint list.

On this form, i want to create a dynamic search : i explain.

First, i create a dropdown list : on this list i set some column names from my sharepoint list : ex : Author, Status, Country, etc.

On a second dropdown i want to see distinct element based on column choose previously.

Ex : in dropdown1, i select Author, so, second dropdown list must show distinct author who add information to my sharepoint list. For exemple : i can see : Robert, Ed, Toto.

If i select one Author on this dropdown list, now, in my gallery, i want to see all lines added to sharepoint per 'Robert' for exemple.

The problem : on dropdown list : i set column manually, but on second drop down dropdown2, powerapps do not understand column name as param :I set on Items : distinct(Sharepointlist; dropdown1.selectedText.value).

Do you have a solution please ? Thank you.

0 Replies