Answered

Counting specific strings in a gallery across multiple Columns

(0) Share

Report

Posted on by BaronKiespert

So I have a gallery in my app that shows statistics of people who have played a game. The players names are entered, and saved. I would like to count how many games a person has taken place in. From the data set I have below a player could be entered in as Player1 during one game and then end up a different player during another game. So how can I count the total times a name occurs in the gallery/dataset?

Player1	Player2	Player3	Player4
Peter	Sam	Lee	Jane
Jane	Lee	Peter	Sam
Lee	Peter	Jane	Sam
Peter	Jane	Sam	Lee

I can successfully count the number of times a name occurs in one column:

CountIf(GalleryPlayerStats.AllItems, Player1 = "Peter") -> result is 2

But I cant figure out how to count multiple columns, I have tried this but it doesn't return the correct number

CountIf(GalleryPlayerStats.AllItems, (Player1 || Player2 = "Peter")) -> result is still 2

So I am not sure how to setup the equation, thanks for the help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @BaronKiespert ,
Try
CountIf( GalleryPlayerStats.AllItems, Player1 = "Peter" ) + CountIf( GalleryPlayerStats.AllItems, Player2 = "Peter" ) + CountIf( GalleryPlayerStats.AllItems, Player3 = "Peter" ) + CountIf( GalleryPlayerStats.AllItems, Player4 = "Peter" )

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.

Was this reply helpful? Yes No
BaronKiespert 40 on at

Like (0)

Report

You know, that makes a lot more sense then what I was trying to do. Thanks

Was this reply helpful? Yes No