Posts

Showing posts from October, 2020

Sorting a SharePoint Cascading dropdown in PowerApps.

Image
  Simple sort function in Power App has the definition of Sort(Source, Expression, SortOption) i recently got a chance to work on using sort in a cascading dropdown. Nothing fancy in this its just you have always seen sort used with filter function in conjunction. But when you use it for a cascading dropdown you need to deal with one extra For All loop.  So your snippet looks something like below. ForAll(     Sort(Filter(         BusinessUnits,// SharePoint list with all cities          Division.Value = ddDivision.Selected.Value     ),Title,Ascending),     {         Value: Title,         // Create a new item with Value/Id, which will save correct          Id: ID// It's important to have Value as the first field!      } ) Remember sorting is done via the Title column and not the Division column.  Also, a bonus tip in order to change the format of dates in power app, All your dates have a format property you can use to change the format of date.