Pie Chart count the 2 Data sharepoint list

(0) Share

Report

Posted on by shientylee

Hi i have a question

i have a 2 Sharepoint list which is SampleData1 and Confident_1

I need to show the value of counts of these 2 sharepoint list

AddColumn(GroupBy(SampleData1, "Username", "Groupcolumn), "Count of Username", CountRows(Groupcolumn)

+AddColumn(GroupBy(Confident_1, "Lastname", "Groupcolumn), "Count of Lastname", CountRows(Groupcolumn) )

Seems doesnt work how to count 2 column? i hope someone responds soon thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @shientylee ,

You are not adding the fields

AddColumns( GroupBy( SampleData1, "Username", "Groupcolumn" ), "Count of Username", CountRows(Groupcolumn) ).'Count of Username' + AddColumns( GroupBy( Confident_1, "Lastname", "Groupcolumn" ), "Count of Lastname", CountRows(Groupcolumn) ).'Count of Lastname'

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
shientylee 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello i tried this code but i have an error with invalid argument type. Expecting one of the following Number, Text or Boolean.

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

Like
a
(0)

Report
Copy link

Link copied!
@shientylee ,

You can try this, but it is really the same thing

With( { wUser: AddColumns( GroupBy( SampleData1, "Username", "Groupcolumn" ), "UserCount", CountRows(Groupcolumn) ), wLast: AddColumns( GroupBy( Confident_1, "Lastname", "Groupcolumn" ), "LastCount", CountRows(Groupcolumn) ) }, wUser.UserCount + wLast.LastCount )

I assume you are putting this on a Label

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
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @shientylee ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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
shientylee 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello sorry for the late reply. im still getting the error Text Number or Boolean. still finding a alternative way or looking to fix the error. 🙂

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @shientylee ,

What type of fields are UserName and LastName ?

Was this reply helpful? Yes No
shientylee 28 on at

Like
a
(0)

Report
Copy link

Link copied!

They are Text

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

Like
a
(0)

Report
Copy link

Link copied!
@shientylee ,

I can see the issue now - the sum of all of that is just going to the total number of records in both lists. Each set on its own will simply place a total of each grouped field in that record. Adding them up (which you could do with (but it is pointless)

With( { wUser: Sum( AddColumns( GroupBy( SampleData1, "Username", "Groupcolumn" ), "UserCount", CountRows(Groupcolumn) ), UserCount ), wLast: Sum( AddColumns( GroupBy( Confident_1, "Lastname", "Groupcolumn" ), "LastCount", CountRows(Groupcolumn) ), LastCount ) }, wUser + wLast )

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
shientylee 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello i tried this but for now i got number values which are incompatible :c
i can work this with 1 Collection List but
with this 2 collection list or 2 data sources still having hard time to fix it. sorry 😞

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

Like
a
(0)

Report
Copy link

Link copied!
@shientylee ,

What I am saying is that you are wasting your time with that structure - you can count both lists

CountRows(SampleData1) + CountRows(Confoident_1)

The AddColumns(GroupBy( . . .)) puts an individual total in each grouped record, so you either want individual totals the you will have a Table), or add them all up which is the same as the above.

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