News and Announcements icon

Power Platform CommunityForums Power Apps - Power Apps Pro Dev & ISV If( CountRows( Filter(...

Power Apps - Power Apps Pro Dev & ISV

Answered

If( CountRows( Filter( Won't work with lots of records. How to re-write it to avoid failure?

(0) Share

Report

Report

Posted on by selhd00

Hi,

Quite new to this; came from... COBOL. Sorry for that. Thanks in advance.

If there are not many records, this works fine. Once we get a relevant set of data, it won't work.

If(

CountRows(

Filter(

Vehicles;

LicensePlate = DataCardValue17.Text

)

);

SubmitForm(EditForm1);;

ResetForm(Form2);

How can we rewrite it to work with any amount of records?

Best.

Categories:

Power Platform Build Tools

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: If( CountRows( Filter( Won't work with lots of records. How to re-write it to avoid failure?

Hi @selhd00,

Actually, the CountRows() function is non-delegable.

If you want to use the CountRows() function to work with any amount of records, I am afraid there is no way to achieve this in Power Apps currently.

As an alternative solution, I think you could combine with a flow to count records:

length(body('Get_items')?['value'])
cchannon 4,702 Super User 2025 Season 1 on at

Like (0)

Report

Re: If( CountRows( Filter( Won't work with lots of records. How to re-write it to avoid failure?

Can you be more specific about what you mean when you say, "it won't work"?

Are you getting a query delegation warning in the app designer UI?

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Leaderboard > Power Apps - Power Apps Pro Dev & ISV

#1

WarrenBelz 75 Most Valuable Professional

#2

mmbr1606 51 Super User 2025 Season 1

#3

MS.Ragavendar 36

Overall leaderboard

Featured topics

Auto-Populate field Power Pages

Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans