Delegation Warning

(0) Share

Report

Posted on by jaimeMtz07

159

Hi Team.

I built an application in power apps and I have these function delegation problems, but I have tried to solve them with some other formulas and it does not work:

Label4= CountIf(Recibo, Title = "Recibido")

in this button I only want to do a record count when the condition is "Recibido"

TextSearchBox1=

SortByColumns(
Filter(
Recibo,
Title = "Recibido",
StartsWith(Destinatario,TextSearchBox1.Text) || StartsWith(Paqueteria,TextSearchBox1.Text) || StartsWith(Proveedor,TextSearchBox1.Text) || StartsWith(Text(PO),TextSearchBox1.Text)
),

"Title",
If(
SortDescending1,
Ascending,
Descending
)
)

with this text box I only want to filter the content according to the value that I write according to the columns of the RECIPIENT, PO .....

Any idea?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jaimeMtz07

This is to get count #1
With( { _Item: Filter( Recibo, Title = "Recibido" ) }, CountRows(_Item) )
Verified answer

gazzo1967 1,151 on at

Like
a
(1)

Report
Copy link

Link copied!

@jaimeMtz07
Delegation issue can be solved using Collections
tthis means that you are not directly trying to filter your data source.
On your first screen

select the screen for example 'screen1'
then in the formula selection change to ONVISIBLE = ClearCollect(colRep, Recibo)
Change your formula to this

TextSearchBox1=
SortByColumns(
Filter(
colRep,
Title = "Recibido",
StartsWith(Destinatario,TextSearchBox1.Text) || StartsWith(Paqueteria,TextSearchBox1.Text) || StartsWith(Proveedor,TextSearchBox1.Text) || StartsWith(Text(PO),TextSearchBox1.Text)
),

"Title",
If(
SortDescending1,
Ascending,
Descending
)
)
your delegation issue should go 🙂
Hope that helps
Gary
PS Consider a thumbs up and mark as Solved if it works 🙂
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jaimeMtz07

Please try this your gallery filter

With( { _Item: Filter( Recibo, Title = "Recibido" ) }, Sort( Filter( _Item, StartsWith(Destinatario,TextSearchBox1.Text) || StartsWith(Paqueteria,TextSearchBox1.Text) || StartsWith(Proveedor,TextSearchBox1.Text) || StartsWith(Text(PO),TextSearchBox1.Text) ), "Title", If( SortDescending1, Ascending, Descending ) ) )
jaimeMtz07 159 on at

Like
a
(0)

Report
Copy link

Link copied!

Great solution, short and easy... uhmmm
jaimeMtz07 159 on at

Like
a
(0)

Report
Copy link

Link copied!

Whats is the difference than the other solution?
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

The collection is going to keep the data in memory until you clear it. Based on the columns this will be resource-intensive. On the other hand, If you use With uses temp variable just to filter and it's a better approach.