cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: BrowseGallery1 not sorted correctly and SortByColumns not working all

That's probably because of User.'Full Name'.

What fields exist in your User lookup? I assumed Full Name is one.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com
richardcampbell
Level: Powered On

Re: BrowseGallery1 not sorted correctly and SortByColumns not working all

If I use this code I can get it to find the Asset Number I input into the "Search items" field:

 

SortByColumns(Filter([@'Asset List'], StartsWith(Text('Asset Number'), TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

 

It still does not sort the list by asset number when the "Search items" field is left blank.

Super User
Super User

Re: BrowseGallery1 not sorted correctly and SortByColumns not working all

If you are expecting it to be sorted by Asset Number, I am not sure how it would since the column you are specifying for sort is Title.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com
richardcampbell
Level: Powered On

Re: BrowseGallery1 not sorted correctly and SortByColumns not working all

Agree, but if I put 'Asset Number" or Text('Asset Number') in the place of "Title", it does not show any list items.

Super User
Super User

Re: BrowseGallery1 not sorted correctly and SortByColumns not working all

So your only issue with this formula is that it doesn't sort, correct? 

 

Please try this to sort by Asset Number: 

 

SortByColumns(Filter(AddColumns('Asset List', "AssetNumberText", Text('Asset Number')), StartsWith(Text('Asset Number'), TextSearchBox1.Text)), "AssetNumberText", If(SortDescending1, Descending, Ascending))

 

Let me know if this helps. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

 

View solution in original post

richardcampbell
Level: Powered On

Re: BrowseGallery1 not sorted correctly and SortByColumns not working all

Doesn't do exactly what I want but it can be remedied by going and making the asset numbers all a five digit number, for example 00056, this is organizing 56 with 562. Thanks for the help Hardit!

Super User
Super User

Re: BrowseGallery1 not sorted correctly and SortByColumns not working all

Glad I could help! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Helpful resources

Announcements
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (4,886)