Answered

Add Search()

(0) Share

Report

Posted on by xFelipeDuartee

Hello Guys!

I have in power apps, sharepoint list with name Compras_RNV_APP and need to add Search() to my gallery.
My font is Compras_RNV_APP and need to connect my TextInput2 and column sharepoint list "NumRC"

My formule items is:

SortByColumns(

With(

{

prefilter: Filter(

Compras_RNV_APP;

AnaliseADM.Value = "VALIDADO PELA ADMINISTRAÇÃO" && ((UC.Value = DropdownCanvas2_8.Selected.Value) || IsBlank(DropdownCanvas2_8.Selected.Value)) && ((Execucao.Value = DropdownCanvas2_9.Selected.Value) || IsBlank(DropdownCanvas2_9.Selected.Value))

)

};

Filter(

prefilter;(IsBlank(Fornecedor) || IsBlank(NumPedido) || IsBlank(DataPEDIDO) || IsBlank(ValorUnitSuprimentos))

&& (!IsBlank(NCM) && !IsBlank(NumRC) && !IsBlank(CodigoZIP) && !IsBlank(DataRC))

)

;

"Created";

SortOrder.Ascending

)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,756 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @xFelipeDuartee ,

You could do this

SortByColumns( With( { prefilter: Filter( Compras_RNV_APP; AnaliseADM.Value = "VALIDADO PELA ADMINISTRAÇÃO" && ( UC.Value = DropdownCanvas2_8.Selected.Value) || Len(DropdownCanvas2_8.Selected.Value) = 0 ) && ( Execucao.Value = DropdownCanvas2_9.Selected.Value || Len(DropdownCanvas2_9.Selected.Value) = 0 ) ) }; Filter( prefilter; ( IsBlank(Fornecedor) || IsBlank(NumPedido) || IsBlank(DataPEDIDO) || IsBlank(ValorUnitSuprimentos) ) && !IsBlank(NCM) && !IsBlank(NumRC) && !IsBlank(CodigoZIP) && !IsBlank(DataRC) && ( Len(TextInput2.Text) = 0 || TextInput2.Text in NumRC ) ) ); "Created"; SortOrder.Ascending )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
xFelipeDuartee on at

Like
a
(0)

Report
Copy link

Link copied!

The logic is correct; there was just a minor formatting error, but I fixed it, and it worked perfectly! Thank you very much! 😊

Was this reply helpful? Yes No