web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps If( CountRows( Filter(...

Power Apps

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 Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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'])

Was this reply helpful? Yes No

Join the conversation