Filters Question

(0) Share

Report

Posted on by Pridez

Good morning / afternoon / night guys, how are you? I hope well!

I have a question and would like your help.

I am trying to filter some columns in my application.

Filter( SortByColumns( Search ( Respostas_Pre_CadastroCC; BuscaNome_1.Text; "Nome_x0020_Fantasia_x003a_"; "Estado_x003a_"; "Insumos_x003a_"; "Regi_x00e3_o_x0020_de_x0020_Atua"; "Materiais_x0020_e_x0020_Equipame"; "Certifica_x00e7__x00f5_es_x003a_"; "Cidade_x003a_"; "Servi_x00e7_os_x0020_Corporativo"; "Servi_x00e7_os_x0020_Industriais");
 "Nome_x0020_Fantasia_x003a_"; If(ordenar=true; Ascending; Descending)
);

 If (Text(Cbx_8.Selected.Value) = "Materiais e Equipamentos"; !IsBlank('Materiais e Equipamentos:'))||
 If (Text(Cbx_8.Selected.Value) = "Serviços Industriais"; !IsBlank('Serviços Industriais:'))||
 If (Text(Cbx_8.Selected.Value) = "Serviços Corporativos"; !IsBlank('Serviços Corporativos:'))||
 If (Text(Cbx_8.Selected.Value) = "Insumos"; !IsBlank('Insumos:'))||
 If (Text(Cbx_8.Selected.Value) = "Energia"; !IsBlank('Energia:'));


 Text(Cbx_9.Selected.Result) in 'Materiais e Equipamentos:' & !IsBlank('Materiais e Equipamentos:')|| 
 Text(Cbx_9.Selected.Result) in'Serviços Industriais:' & !IsBlank('Serviços Industriais:')|| 
 Text(Cbx_9.Selected.Result) in'Serviços Corporativos:' & !IsBlank('Serviços Corporativos:')||
 Text(Cbx_9.Selected.Result) in'Insumos:' & !IsBlank('Insumos:')|| 
 Text(Cbx_9.Selected.Result) in'Energia:' & !IsBlank('Energia:');
 

 Text(Cbx_10.Selected.Result) in 'Estado:' & !IsBlank('Estado:');
 Text(Cbx_11.Selected.Result) in 'Região de Atuação:' & !IsBlank('Região de Atuação:');
 Text(Cbx_12.Selected.Result) in 'Certificações:' & !IsBlank('Certificações:');
 )

But the filters are only working if the first filter is selected. can anybody help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,415 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Pridez ,

Free-typed (so watch commas/brackets etc), but I try something like this

With( { w8:Cbx_8.Selected.Value; w9:Cbx_9.Selected.Result; w10:Cbx_10.Selected.Result; w11:Cbx_11.Selected.Result; w12:Cbx_12.Selected.Result ]; SortByColumns( Search( Filter( Respostas_Pre_CadastroCC; Switch( w8, "Materiais e Equipamentos"; !IsBlank('Materiais e Equipamentos:'), "Serviços Industriais"; !IsBlank('Serviços Industriais:'); "Serviços Corporativos"; !IsBlank('Serviços Corporativos:'); "Insumos"; !IsBlank('Insumos:') "Energia"; !IsBlank('Energia:') )|| w9 in 'Materiais e Equipamentos:' || w9 in'Serviços Industriais:' || w9 in'Serviços Corporativos:' || w9 in'Insumos:' || w9 in'Energia:' || Text() in 'Estado:' || //not sure what this is w11 in 'Região de Atuação:' || w12 in 'Certificações:' ); BuscaNome_1.Text; "Nome_x0020_Fantasia_x003a_"; "Estado_x003a_"; "Insumos_x003a_"; "Regi_x00e3_o_x0020_de_x0020_Atua"; "Materiais_x0020_e_x0020_Equipame"; "Certifica_x00e7__x00f5_es_x003a_"; "Cidade_x003a_"; "Servi_x00e7_os_x0020_Corporativo"; "Servi_x00e7_os_x0020_Industriais" ); "Nome_x0020_Fantasia_x003a_"; If( ordenar=true; Ascending; Descending) ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 155,415 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Pridez ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No