by | Filter Filter(SharePoint List or Table,condition1[,condition2] ) Example: Filter(MyDataSource,Title = MyTerm) Result: A table with all records where Title = MyTerm Sort and Filter Sort(Filter(SharePoint List or Table,condition1[,condition2] ) , SortColumn) Example: Sort(Filter( MyDataSource,Title = MyTerm),Age) Result: A table with all records where Title = MyTerm sorted by Ascending Age. Sort with Distinct Filter Distinct(Sort(SharePoint List or Table,ColumnName ) , ColumnName ) Example: Distinct(Sort( MyBookList, colAuthor),colAuthor)) Result: A table with one occurrence of each Author’s Name sorted by Author’s Name. |
