Answered

Search with dropdownlist and blanck

(0) Share

Report

Posted on by Khedidja1990

Hi;

i have table with data from SharePoint list, i add seven filters as dropdown list, but i have a problem when some of filter are blanc, may search don't display data, i don't know how to manage my search when some filter are blanck, this is my code

ClearCollect(
 ListeRetombee;
 Filter(
 Retombées;
 'Nom '.Value = RechNom.SelectedText.Titre;
 'Mois'.Value = RechMois.Selected.Value;
 'Année'=annee.Text;
 Approuvée=AppFilter.SelectedText.Value;
 'Thème'.Value=RechThPrin.SelectedText.Titre;
 'Thème2'.Value=RechThSec.SelectedText.Titre;
 Secteur.Value = RechSec.SelectedText.Title ;
 Approbateur.DisplayName=RechApp.SelectedText.DisplayName

 )
);;

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi

I guess you mean you have blank input to the filter (like
'Nom '.Value = RechNom.SelectedText.Titre; //RechNom.SelectedText.Titre is blank
To solve this you can put all the filter statement in a if. But remember to allways have a fallback condition, or it will not work. Example:
ClearCollect( ListeRetombee; Filter( Retombées; If(!IsBlank(RechNom.SelectedText.Titre); 'Nom '.Value = RechNom.SelectedText.Titre; ID>0 ); //Or some other filter that will get all the items. IF(!IsBlank(RechMois.Selected.Value) 'Mois'.Value = RechMois.Selected.Value; ID>0 ); ...<continue with all fields> ) );;
Please note ID>0 is not a delegable expression if you are working directly with the data from sharepoint, so you might use another expression. Alternativly you can make a new column in you datasource called __ID (or something). And run a flow to make it equal the ID every time you make a new record.

If I misunderstood your question, please let me know with some more information about what you try to do.

Was this reply helpful? Yes No
Khedidja1990 50 on at

Like (0)

Report
Copy link

Link copied!

Maybe I misexpressed my need, first of all I thank you for your answer. what I want to do for example if my filter name = All or blanck and filter sector = sector1 and filter month = April, and all other filter are on All or blanck I want my search to show me all the names that have sector 1 and the month of April

Was this reply helpful? Yes No
Khedidja1990 50 on at

Like (1)

Report
Copy link

Link copied!

it's work correctly, thank you

Was this reply helpful? Yes No