web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Cascading Drop-Down an...

Power Apps

Answered

Cascading Drop-Down and Sort Order

(0) Share

Report

Report

Posted on by stubbo

11

Hi Folks -

Already found some great answers on here along the way so thank you, but I'm currently stuck with this...

We have some nice cascading drop-downs on a Power Apps form

Based on this article https://www.techmikael.com/2019/01/a-no-nonsense-solution-to-implement.html thanks Mikael 🙏

People choose a Business Unit, then relevant Team (connected to a SharePoint list named Team)... here's the form syntax:

ForAll(Filter(Team,BU.Id=BuSelector.Selected.Id),{Value:Title, Id:ID})

This was all fine until we had to add another item to the list, now in the drop-down for Team the additional list item appears at the end

We prefer the items to list alphabetically and have tried various Sort and SortByColumns options in the syntax but can't make it work

Does anybody have any suggestions?

Thanks, Jim

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@stubbo

Please consider changing your Formula to the following:

SortByColumns( ForAll(Filter(Team,BU.Id=BuSelector.Selected.Id),{Value:Title, Id:ID}), "Value" )

I hope this is helpful for you.

Was this reply helpful? Yes No
stubbo 11 on at

Like (1)

Report
Copy link

Link copied!

Thanks Randy, really appreciate your time on this... your solution works perfectly 👍

Was this reply helpful? Yes No

Join the conversation