web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Count or concatenate 2...

Power Apps

Unanswered

Count or concatenate 2 different items in the same column/field

(0) Share

Report

Report

Posted on by esleonardo

9

Hi! Just want to seek for your help on how I will count or concatenate 2 items in the same field.

TABLE1

For example, I want to count the total in 'Team One' and 'Team Two'

My formula is not working...

CountIf(TABLE1, 'Team' = "Team One" && 'Team' = "Team Two")

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Community Power Pla... on at

Like (1)

Report
Hello,

With the condition that you are using you are saying:
Count only the rows which have the team with Team One and Team Two at the same time which is not possible since an object can only have one team!

I would do it like this:

CountIf(dataSource,Team="Team One") + CountIf(dataSource,Team="Team Two")
The code I wrote as example might not be the exact one you need to change the variable names according to your needs.

Was this reply helpful? Yes No
esleonardo 9 on at

Like (0)

Report

Thanks @Anonymous It works!

Was this reply helpful? Yes No
esleonardo 9 on at

Like (0)

Report

Thanks @Anonymous! It works!

Was this reply helpful? Yes No

Join the conversation