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

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
T_A_M 332 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@T_A_M ,

Is Column1 numeric and what can you see in Colleciton1

Was this reply helpful? Yes No
T_A_M 332 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@T_A_M ,

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

Was this reply helpful? Yes No