Answered

Sort by Value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I´ve got an App, which shows several Projects in a Gallery. The Projects are saved in a SQL-Table.

The Budget is sortet alphabetical and not by value. I set Budget as Value(Budget) but it wont sort it right. Did somebody got an Idea?

2022-08-29 10_59_59-Power Apps.png

Sort(
Source_with_filters_and_stuff;
Switch(
 DrpSort.SelectedText.Value;
 [...];
 "Budget";
 Value(Budget);
 [...]
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Waegemma 583 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I notice in the screenshot that the budget sum is preceded by "Budet :", could there be a spelling mistake in the original column name?

Marc

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

Like (0)

Report
Copy link

Link copied!

Its just a Mistake in the Label, not in the Data but thanks for the Info.

Was this reply helpful? Yes No
Waegemma 583 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Normally, if the column is of the Valuta type and you don't use Value(), the sort is ok.

Sort( Source_with_filters_and_stuff; Switch( DrpSort.SelectedText.Value; [...]; "Budget"; Budget; [...] ) )

Is there a reason you use Value?

Marc

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

Like (0)

Report
Copy link

Link copied!

I already tried but it´s the same result 😞

Was this reply helpful? Yes No
Waegemma 583 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Could you post the complete sort formula? (without the [...])

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

Like (0)

Report
Copy link

Link copied!
Sort( If( IsBlank(TxtSearch); Filter( vP_Projects_for_SWOT; Mail = User().Email ); Search( Filter( vP_Projects_for_SWOT; Mail = User().Email ); TxtSearch.Text; "projectname"; "projectnumber"; "customernumber" ) ); Switch( DrpSort.SelectedText.Value; "Name"; projectname; "Projektnummer"; projectnumber; "Kundennummer"; customernumber; "Budget"; Budget; "Kostenstelle"; costcenter; "Start"; startingdate; "Ende"; endingdate ); If( DESC; Descending; Ascending ) )

Was this reply helpful? Yes No
Waegemma 583 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Thank you. I think the "Budget" option might be skipped. Could you try the following code to check this? I set the Budget sort as Default, so you don't have to select an item in the dropdown, this is just for testing:

Sort( If( IsBlank(TxtSearch); Filter( vP_Projects_for_SWOT; Mail = User().Email ); Search( Filter( vP_Projects_for_SWOT; Mail = User().Email ); TxtSearch.Text; "projectname"; "projectnumber"; "customernumber" ) ); Switch( DrpSort.SelectedText.Value; "Name"; projectname; "Projektnummer"; projectnumber; "Kundennummer"; customernumber; "Kostenstelle"; costcenter; "Start"; startingdate; "Ende"; endingdate; Budget ); If( DESC; Descending; Ascending ) )

Was this reply helpful? Yes No
Waegemma 583 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

forgot to explain: your gallery should be sorted by Budget as a result

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

Like (0)

Report
Copy link

Link copied!

It is sorted by budget but still alphabetical

Was this reply helpful? Yes No
Waegemma 583 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Sorry, I misunderstood: I thought it didn't sort on Budget, but alphabetical on Title... Now I see what you mean: it sorts on the numbers left to right. Okay, so this has something to do with the valuta/numbers settings. I will look into this, could take ten minutes 🙂

Was this reply helpful? Yes No