Announcements
Goodnight,I have two galleries, one filtered by user and the other global from the database, how can I count the requests that are filter?
@CarlosN You appear to have done it correctly using this code
CountRows(Filter('Solictudes Expres'; Estatus.Value="NUEVA"))
COUNTROWS cannot use delegation in SharePoint. That's why you are receiving a warning. This means by default your formula will only count the 1st 500 rows. Of course, you can increase this to 2,000 rows in the advanced settings menu.If none of your categories will ever have over 2,000 rows in them you can safely ignore the warning. Otherwise, you would have to change to a different datasource: SQL or CDS to use COUNTROWS with delegation.
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Thank you, But, I want to count the small gallery. That Gallery has a filter by user, you can see that there are only three records 2 new and 2 pending
@CarlosN I don't see the code you are using to filter by user. Please show your code for the Items proeprty of the small gallery.
Here's an example of what the COUNTROWS code might be. But's its really just a guess without having the proper information.
CountRows( Filter( 'Solictudes Expres'; Estatus.Value="NUEVA" 'Created By'.Value = User().Email ) )
Attach capture
@CarlosN
Like this...
CountRows( Filter( 'Solictudes Expres'; Estatus.Value="NUEVA"; EmailUsario = VarEmail ) )
Thanks,
for your help.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 993
Valantis 675
11manish 545
