Answered

If( CountRows( Filter( LookUp()))) Deligation Problems

(0) Share

Report

Posted on by AlvinCassar

I have this line of code, to make an icon visible and not visible. Which should be working properly, I am getting gathering problems from network errors (which I believe is for delegation), I will be having over 2000 rows so I cannot just change from advance settings.


If( CountRows( Filter(Collection, LookUp(Collection, ID = ThisItem.'ID').State = StateChoice.Unattended)) > 0, true, false)

Is there a way to make it function without these problems?

Thank you

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

try this:

With( {vFilter:Filter(Collection, LookUp(Collection, ID = ThisItem.'ID').State = StateChoice.Unattended)}, CountRows(vFilter) > 0 )

It is not necessary to use 'If(..., true, false)' because the return of 'CountRows(...) > 0' is true or false

I hope it helps 🙂
AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi this doesn't work fully, examples below.

Car Colour State
Toyota blue inprogress
Toyota red unattended
Toyota yellow unattended

For the example above it is returning with 0, while it should have 2 and make the visible as true. Also, I am trying to do a column which is either showing 500 for true and 0 for false. Just used the code you submitted before and removed the > 0.

Thanks.
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Question: Do you want to Filter all the unattended items, right? is there any extra filter?
AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!

I need to get the count of unattended items, for the example above it would be 2 and the number placed in a label. If there is 1 or more inside which are unattended for a specific car for example an icon would be visible or not. And if possible a collection containing each item which has the same car type and are unattended, which can be used later on.
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I see, so try this:

With( {vFilter:Filter(Collection, State = StateChoice.Unattended)}, CountRows(vFilter) > 0 )

and make sure 'StateChoice.Unattended' match the data in 'State' column
AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!

I need to match the Id aswell, for example results of Toyota that are unattended, and results of Audi which are unattended.
Verified answer

AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!
With( { vFilter: Filter('Vulnerability Tables', 'CVE ID Text' = ThisItem.'CVE ID' && State = StateChoice.Unattended) }, CountRows(vFilter) > 0 )

Using this code fixed my problem, essentially combining both filters into 1.