Forum Discussion
Dynamique filter on dropdown
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.