Unanswered

Counting the contents of multiple Sharepoint columns

(0) Share

Report

Posted on by T_A_M

332

I'm using a data table in Power Apps to display the contents of a SharePoint text column so that it counts the numbers of each distinct entry. I create a collection with the following formula:

ClearCollect(Collection1,
AddColumns(
GroupBy('DataSource',"Column1","Rows"),
"RowCount",
CountRows(Rows)
)
)

Then I use Collection1 for the Items property of my data table.

Is there a similar way to count the contents of multiple SharePoint columns? I've tried something like GroupBy('DataSource', Sum("Column1"+"Column2"),"Rows") but that doesn't work.

Thank you!

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @T_A_M ,

The issue here is that Column1 has multiple items in "Rows" containing Column2. I cannot test this, but it should work

ClearCollect( Collection1, AddColumns( GroupBy( 'DataSource', "Column1", "Rows" ), "RowCount", CountRows(Rows), "MyTotal", Column1 + Sum(Rows,Column2) ) )

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
T_A_M 332 on at

Like
a
(0)

Report
Copy link

Link copied!

I gave that a try, but the result is that the column in my data table that is supposed to show the totals only shows zeros.
The Items property of the data table is Collection1, and the text property of the column that's supposed to show the totals is ThisItem.MyTotal.
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@T_A_M ,

Is Column1 numeric and what can you see in Colleciton1
T_A_M 332 on at

Like
a
(0)

Report
Copy link

Link copied!

Column1 is a text column.

In Collection1, I see Column1 with text items in it, a column called RowCount with numbers in it, a column called Rows that contains table icons, a column called Title with nothing it, and a column called MyTotal with all zeros in it.
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@T_A_M ,

You cannot Sum Text columns, which is why this does not work.