Unanswered

How to get Power Apps display results of multi-select items in a specific order.

(0) Share

Report

Posted on by Darren11

I currently have a form giving the user the option to select which day of a week they plan to telework. In that form, I have a dropdown menu showing Monday ~ Friday options.

When a user selects the days in a random order, the results display in that same random order.

How can I get the results to automatically display in a Monday ~ Friday style of order?

Thanks in advance for your help.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Darren11 ,

What does your collection look like in the properties of the items in your Combobox?
I have a test for your reference.
Concat(SortByColumns(AddColumns(ComboBox3.SelectedItems,"id",Switch(Value,"Monday",1,"Tuesday",2,"Wednesday",3,"Thursday",4,"Friday",5)),"id",SortOrder.Ascending),Value,";")

Best Regards,
Dezhi
Darren11 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Dezhi,
Thanks for responding. Here is what I have for Items.
Items = Choices([@Telework_Schedule].Telework_Schedule)
Basically, I am pulling from a SharePoint list. I don't mind setting it up as you show here. I just need to make sure it saves back to the same SharePoint list. I will try your solution later today.
Let me know if you have other suggestions.
Darren11 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again Dezhi,
After applying the code you suggested, I adjusted your ComboBox3 entry to my DataCardValue10. The other issue I am seeing is with the first Value after Switch. I am not sure if this is supposed to be replaced by something else.
Below is a snap show if the code in my system.

I have made several adjustments, but so far nothing better than this. Please let me know what other changed I should make.

Thanks greatly for your help.
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Darren11 ,

Could you please show your error information?
In which control of your code is written?
My code is written under label.

Best Regards,
Dezhi