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

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
Highlighted
Regular Visitor

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.

Highlighted
Super User II
Super User II

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
Highlighted
Regular Visitor

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.

Highlighted
Super User II
Super User II

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

Highlighted
Regular Visitor

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!

Highlighted
Super User II
Super User II

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (7,224)