Unanswered

Property Items in a gallery

(0) Share

Report

Posted on by JM-07111833-0

I'm trying to put two commands in the items property in my gallery.
I need to put SortByColumns and I also want an If for other controls.
Here's what I have:

SortByColumns(
DemandasGLPCE;
"cr303_numerodemanda";
If(
classNumDemanda = true;
SortOrder.Ascending;
SortOrder.Descending
)
);;

If(MyVar=1; Filter(DemandasGLPCE;Elaborador=User().Email); If(MyVar=2;DemandasGLPCE;Search(DemandasGLPCE;Txt_Pesquisa.Text;Elaborador;Descricao;DOD;ETP;PB;Obs;NumeroDemanda;Pedido)))

Both commands, individually, work perfectly, but I can't run it as shown above.

NOTE: I used two semicolons to separate the commands, because my Office is in Portuguese.

Does anyone have a solution, please?

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (0)

WarrenBelz 143,487 on at

Like (0)

Report

Property Items in a gallery

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffe
WarrenBelz 143,487 on at

Like (1)

Report
Property Items in a gallery

Hi JM-07111833-0

This should do the job
SortByColumns( Filter( DemandasGLPCE; ( MyVar=1 && Elaborador = User().Email ) || ( MyVar=2 && ( Txt_Pesquisa.Text in Elaborador || Txt_Pesquisa.Text in Descricao || Txt_Pesquisa.Text in DOD || Txt_Pesquisa.Text in ETP || Txt_Pesquisa.Text in PB || Txt_Pesquisa.Text in Obs || Txt_Pesquisa.Text in NumeroDemanda || Txt_Pesquisa.Text in Pedido ) ) ) ); "cr303_numerodemanda"; If( classNumDemanda; SortOrder.Ascending; SortOrder.Descending ) );;

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee