Answered

Countrows

(0) Share

Report

Posted on by Community Power Pla...

Hi I want to count how many are in share point:

so this is working Sharepoint1 : CountRows(Filter(AddColumns(landname,"helper",If(Value(ID_Label.Text) in Goals.Id,"true","false")).helper,helper ="true"))

This is also working Sharepoint2 :CountRows(Filter(AddColumns(City,"helper2",If(Value(ID_Label.Text) in City.Id,"true","false")).helper2,helper2 ="true") )

but i want to count both sharepoints together

how can i count them together in powerpoint...

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

In a CountRows you can only have 1 DataSource.

If you want, I think that you can do something like this:

CountRows(Filter(AddColumns(landname,"helper",If(Value(ID_Label.Text) in Goals.Id,"true","false")).helper,helper ="true")) + CountRows(Filter(AddColumns(City,"helper2",If(Value(ID_Label.Text) in City.Id,"true","false")).helper2,helper2 ="true") )

That will be sum the number of rows of the first filter and the number of rows of the second filter

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank uit works
how about if i want to concat in 2 different sharepoints i have also here the same problem. ( I want to concat the countries from both sharepoints in one Label)
sharepoint 1 : Concat(Distinct(Filter(City, ThisItem.ID in City.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land, ", ")
share point 2 : Concat(Distinct(Filter(Landname, ThisItem.ID in Goals.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land ", ")

Was this reply helpful? Yes No
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

I did not understand...

But I think that what you want is this:

Concat(Distinct(Filter(City, City.Id = ThisItem.Id).IDLand,IDLand), ", ",LookUp(Land, Result.Id = ID).Land)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

yeah i want the countries from different share points in one label.
sharepoint 1 : Concat(Distinct(Filter(City, ThisItem.ID in City.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land, ", ")
share point 2 : Concat(Distinct(Filter(Landname, ThisItem.ID in Goals.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land ", ")
Both are working but how can i combine them together in one label

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like (1)

Report
Concat(Distinct(Filter(City, ThisItem.ID in City.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land, ", ") & Concat(Distinct(Filter(Landname, ThisItem.ID in Goals.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land ", ")
?

Was this reply helpful? Yes No
Verified answer

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (1)

Report
Concat(Distinct(Filter(City, ThisItem.ID in City.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land, ", ") & Concat(Distinct(Filter(Landname, ThisItem.ID in Goals.Id).IDLand,IDLand), LookUp(Land, Result.Id = ID).Land ", ")

Use & or AND to achieve this.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No