I have few Sharepoint lists with similar columns which I get into collection
MyCollection is Items property for MyGallery
If try to sort MyCollection by any column (SortByColumns( MyCollection,"Column1") it doesnt change how its sorted in MyGallery
Anything I am doing wrong here?
Could you provide the actual column names that you are trying to sort. The syntax for the function is:
SortByColumns( Table, ColumnName1 [, SortOrder1, ColumnName2, SortOrder2, ... ] )
The table can be a collection or datasource. The ColumnName1 refers to the actual name of the column in the collection. SortOrder refers to either Ascending or Descending. The secondary sorts are optional as is the primary sort if it is Ascending. Check the column names in the collection to make sure that they are the same. The ColumnName must be enclosed in double quotation marks. For SharePoint and Excel data sources that contain column names with spaces, specify each space as "_x0020_". For example, specify "Column Name" as "Column_x0020_Name".
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand