PowerApp Sort function

%3CLINGO-SUB%20id%3D%22lingo-sub-1231460%22%20slang%3D%22en-US%22%3EPowerApp%20Sort%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1231460%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3EI'm%20struggling%20with%20a%20sort%20button.%20I%20would%20like%20to%20sort%20on%20the%20date%20of%20the%20browse%20gallery.%20The%20oldest%20records%20must%20be%20on%20top%20instead%20of%20the%20bottom.%20Can%20someone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20these%20syntaxes%20with%20no%20result%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ESortByColumns(%5B%40'Declaraties%20Etesian'%5D%3BText(%3CSTRONG%3E%22ThisItem.Datum%22%3C%2FSTRONG%3E%3B%22%5B%24-en-US%5Dmmddyyyy%22)%3B%20Descending%3C%2FLI%3E%3CLI%3ESortByColumns(%5B%40'Declaraties%20Etesian'%5D%3BText(%22Thisitem.datum%22%3B%3CSTRONG%3E%22%5B%24-nl-NL%5DToday()%22)%3B%20%3C%2FSTRONG%3EDescending)%3C%2FLI%3E%3CLI%3ESortByColumns(%5B%40'Declaraties%20Etesian'%5D%3BText(%3CSTRONG%3E%E2%80%9CDataCardValue2%22%3C%2FSTRONG%3E%3B%22%5B%24-en-US%5Dmmddyyyy%22)%3B%20Descending)%3C%2FLI%3E%3CLI%3ESortByColumns(%5B%40'Declaraties%20Etesian'%5D%3BText(%22DataCardValue2%22%3B%22%3CSTRONG%3E%5B%24-nl-NL%5DToday%3C%2FSTRONG%3E()%22)%3B%20Descending)%3C%2FLI%3E%3CLI%3ESortByColumns(%5B%40'Declaraties%20Etesian'%5D%3BText(%3CSTRONG%3E%22Body1%22%3C%2FSTRONG%3E%3B%22%5B%24-en-US%5Dmmddyyyy%22)%3B%20Descending)%3C%2FLI%3E%3CLI%3ESortByColumns(%5B%40'Declaraties%20Etesian'%5D%3BText(%22Body1%22%3B%3CSTRONG%3E%22%5B%24-nl-NL%5DToday()%22)%3C%2FSTRONG%3E%20%3B%20Descending%3C%2FLI%3E%3CLI%3E%3CP%3ESortByColumns(%5B%40'Declaraties%20Etesian'%5D%3BText(%22Created%22%3B%22%5B%24-en-US%5Dmmddyyyy%22)%3BDescending)%26nbsp%3B%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1231460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi Guys,

I'm struggling with a sort button. I would like to sort on the date of the browse gallery. The oldest records must be on top instead of the bottom. Can someone help me?

 

I have tried these syntaxes with no result:

 

  • SortByColumns([@'Declaraties Etesian'];Text("ThisItem.Datum";"[$-en-US]mmddyyyy"); Descending
  • SortByColumns([@'Declaraties Etesian'];Text("Thisitem.datum";"[$-nl-NL]Today()"); Descending)
  • SortByColumns([@'Declaraties Etesian'];Text(“DataCardValue2";"[$-en-US]mmddyyyy"); Descending)
  • SortByColumns([@'Declaraties Etesian'];Text("DataCardValue2";"[$-nl-NL]Today()"); Descending)
  • SortByColumns([@'Declaraties Etesian'];Text("Body1";"[$-en-US]mmddyyyy"); Descending)
  • SortByColumns([@'Declaraties Etesian'];Text("Body1";"[$-nl-NL]Today()") ; Descending
  • SortByColumns([@'Declaraties Etesian'];Text("Created";"[$-en-US]mmddyyyy");Descending) 

0 Replies