Hi I have a gallery with this formula:
ith(
{ControleDesp:ControleDespesasAdministrativas; EnderecosCont:ControleEnderecos};
Sort(
Filter(ControleDesp;
DESPESA = DespesaEscolhida;
Ano = Text(AnoEscolhido);
dpdFiltroEnd.Selected.Endereco = Blank() Or RefIDEnd = LookUp(EnderecosCont;Endereco = dpdFiltroEnd.Selected.Endereco).Idend
);
RefIDEnd;Ascending)
)
Today in tests I notice that filter is not showing all items (my sharepoint list has 3862 items and growing.
What I have to do to have no delegations problems and show all items?
Thanks in advance
Solved! Go to Solution.
I will try some bracketing from the syntax I know (yours is European, but this should work) and a bit of different logic
With(
{
EnderecosID:
LookUp(
EnderecosCont;
Endereco = dpdFiltroEnd.Selected.Endereco
).Idend
};
Sort(
Filter(
ControleDespesasAdministrativas &&
DESPESA = DespesaEscolhida &&
Ano = Text(AnoEscolhido) &&
(
dpdFiltroEnd.Selected.Endereco = Blank() ||
RefIDEnd = EnderecosID
)
);
RefIDEnd
)
)
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
Hi @alessandramaced ,
That is because With() is a "hidden" Delegation limit - it will only "collect" up to your Delegation limit of items after any Delegable Filter is applied to it. As you have not filtered either list, you will only get a maximum of 2,000 on each, however you need the statement on the ControleEnderecos List as relational lookups are not Delegable - the below should work as long as your ControleEnderecos list is under 2,000 items (and you have your limit set to this)
With(
{EnderecosCont:ControleEnderecos};
Sort(
Filter(
ControleDespesasAdministrativas;
DESPESA = DespesaEscolhida;
Ano = Text(AnoEscolhido);
dpdFiltroEnd.Selected.Endereco = Blank() Or
RefIDEnd = LookUp(
EnderecosCont;
Endereco = dpdFiltroEnd.Selected.Endereco
).Idend
);
RefIDEnd;
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.
Visit my blog Practical Power Apps
Still not working with records over 2000 in ControleDespesasAdministrativas
I will try some bracketing from the syntax I know (yours is European, but this should work) and a bit of different logic
With(
{
EnderecosID:
LookUp(
EnderecosCont;
Endereco = dpdFiltroEnd.Selected.Endereco
).Idend
};
Sort(
Filter(
ControleDespesasAdministrativas &&
DESPESA = DespesaEscolhida &&
Ano = Text(AnoEscolhido) &&
(
dpdFiltroEnd.Selected.Endereco = Blank() ||
RefIDEnd = EnderecosID
)
);
RefIDEnd
)
)
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
My language is portuguese (brazil).
I try another way.
Did a collection for ControleDespesasAdministrativas with filter so never will have more than 2000 items form me.
And then did a simple filter for the filtered collection. Now is ok .
Thank you very much
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
195 | |
69 | |
50 | |
39 | |
30 |
User | Count |
---|---|
248 | |
112 | |
95 | |
91 | |
72 |