I need to sort a field within a gallery. I created a gallery to display fields stored in my collection. I need to place my "NHPNum" field in ascending order. I'm using the below and returning an error.
"varBuilderCase" is my variable to return the information link to a particular opportunity ID.
My original syntax that is working is :NHPNum
Which of course is just displaying the values for this field. The issue is my list of records in the gallery is not in order. Any suggestions are appreciated. Thanks in advance.
The errors are: "The function 'Search' has some invalid arguments." & "The function 'SortByColumns' has some invalid arguments.
But perhaps I'm using the wrong syntax altogether. In the Text property for this field: HNPNum and the gallery is connected to HPCollection. I return the following results:
I need to sort NHPNum in ascending order. When I did a simple sort formula: Sort(HPCollection,NHPNum,Ascending) my error was "Expected Text Value". So any assistance to get it in ascending order would be appropriated. Thanks
Hi @Fleming ,
Could you tell me how do you set variable varBuilderCase?
I need to know the data type of varBuilderCase.
Please make sure that "varBuilderCase.OpportunityID" is text type.
The right syntax of Search function is:
Search( Table, SearchString, Column1 [, Column2, ... ] )
The second parameter should be string.
What's more, you should change SortByColumns function too.
Please use formula like this:
You need to use "" on both sides of the fieldname.
SortOrder.Ascending is the default. You do not need to list it.
Here are docs about these two functions for your reference:
@v-yutliu-msft The variable is set multiple steps back when the user enters the ID. This pulls information saved for the given opportunityID from my datasource (SharePoint) and save it to the collection (HPCollection). OpportunityID is a text field.
I did updated the search and sortbycolumn syntax to your suggestion and I received the attached errors. When I hoover over NHPNum it states the field does not exist. I also included an image of the field from my collection. At this point, I'm ok with removing the search functionality if I can get assistance on a simple ascending sort for NHPNum which is a number field in my collection. Thanks in advance.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.