Unanswered

Sort powerapos gallary by calculation field

(0) Share

Report

Posted on by Sprotest

I appoligies it this appears twice. I was having log in issues.

I have built an app for sports league. I have two excel tables. First contains user entered game results. Ie. Winning team, scores, etc. The second has team names and teirs since they play across teirs.

In my galary of teirs I have added field with countif winning team in first table equals team name in second table. This gives me total of games won.. I now want to sort by this value to have team with most wins at top. But I can't get it to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sprotest ,

What is the Items of your gallery and where have you put your CountIf Code (and what is it)

Was this reply helpful? Yes No
Sprotest 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren.
The two items in my form from my schooling table is school and teir. I have manually added wins, losses, game's played. In each of these I did different calculations.
I placed the formula. In the text option. The formula is as follows
CountIf(RawData,Winning_x0020_Team= ThisItem.School && Who_x0020_played_x0020_this_x0020_game_x003f_="Boys"

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sprotest ,

I need the Items code of your gallery.

Was this reply helpful? Yes No
Sprotest 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Currently I am back to
Sort(SchoolsInfo,Teir, Ascending)

I tried AddColumns(SchoolsInfo, "GamesWon",
Then my countif. But that did not work.

Was this reply helpful? Yes No