Best way to get the count of a column that contains multiple lookups?

(1) Share

Report

Posted on by pmwhelan

377

I have a Canvas App that displays data from some SharePoint Lists.

Companies is a list of Companies 🙂

Articles is a list of Articles about those Companies.

An Article can be about one or more Companies.

I do a Lookup from the Articles List to the Companies Lists.

I have two galleries.

Is there a way to show the amount of Articles about a Company in the Companies Gallery?

The Articles and Companies galleries are one two different pages.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes do a CountRows with a Filter.

Or @pmwhelan You can use a:
CountIf(Articles ,companyLookupId=ThisItem.Id))

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
g1224 348 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You can use something like :
CountIf(Articles ,companyLookupId=ThisItem.Id)).
To avoid delegation you can, use collections and put countRows over collection.

Was this reply helpful? Yes No
pmwhelan 377 on at

Like
a
(0)

Report
Copy link

Link copied!

Is CountIf delegable to SPO?
I thought not...
https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint

Was this reply helpful? Yes No
g1224 348 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

No its not delegable . You can use countif if your data limit is less . If you have to handle more records , go with delegable functions/collection method .
Try following this thread :https://rezadorrani.com/index.php/2020/08/07/power-apps-count-rows-in-a-sharepoint-list-library-avoid-delegation/ . Credits to Reza Dorrani.

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pmwhelan ,

If your Filter returns less records than your Delegation limit, you can do this

With( { wComp: Filter( Articles, companyLookupId = ThisItem.Id ) }, CountRows(wComp) )

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

Was this reply helpful? Yes No