Help with proper use of If( and With(

[Richard95]

Hello,
Could you help me to use this If( with with(

this is code

With(
If(
IsBlank(TextInput1.Text);
Sort(
Filter(
Nipon_P1;
'Estado docto'="Comprometido"
);
Numero_docto;
Descending
);
!IsBlank(TextInput1.Text);
Sort(
Filter(
Nipon_P1;
Numero_docto=(TextInput1.Text)

);
Ubicacion;
Descending
)
{
records:Nipon_P1
};
ForAll(
Sequence(CountRows(records));
Patch(
Last(
FirstN(records;Value));
{rowNumber: Value}

)

)
)
)

[WarrenBelz · Accepted solution]

Hi @Richard95 ,

Something like this

With(
   {
      wList:
      Sort(
         Filter(
            Nipon_P1;
            'Estado docto' = "Comprometido" &&
            (
               IsBlank(TextInput1.Text) ||
               Numero_docto = TextInput1.Text
            )
         );
         If(
            IsBlank(TextInput1.Text);
            Ubicacion;
            Numero_docto
         );
         Descending
      )
   },
   ForAll(
      Sequence(CountRows(wList));
      Patch(
         Last(
            FirstN(
               wList;
               Value
            )
         );
         {RowNumber: Value}
      )
   )
)

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.

Visit my blog Practical Power Apps

[Richard95]

Hello, thank you very much, it worked perfectly, I only made a few adjustments and it is fully operational

😄