Answered

Filter, split and sort Sharepoint text column to create a dropdown in Powerapps

(0) Share

Report

Posted on by JDsBuddy

Hello! I'm a fairly inexperienced Powerapps user and I'm struggling with trying to Filter, Split and Sort a Sharepoint text column to create a cascading dropdown.

I've figured out how to filter: Filter(Media, Title = Dropdown4.Selected.Result)

And I've figured out how to Split and Sort: Sort(Split(ThisItem.IssueDateTest, "; "),Descending)

I just can't figure out how to combine the two to create the cascading dropdown I need.

I'm sure this pretty simple ... So I really appreciate any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JDsBuddy ,

I'm a little bit confused about your scenario/objective. Can you are more details about what you are trying to do ?

Was this reply helpful? Yes No
JDsBuddy 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Hopefully I can lay this out without confusing everyone. I have a Sharepoint list that contains information on all the different media options agents can place ads in. We're trying to create an order form using a custom canvas.

So what we need to have happen is when someone selects a media from the Title dropdown, the IssueDates dropdown needs to displays only the options for that Title.

I do have that part working with the filter. but the IssueDates is a string of text separated by ";", so if I only apply the filter, the choices display as a line of text instead of choices in the dropdown.

So I need to filter the IssueDate field to display only the dates for the Title selected in the Title dropdown, but the IssueDate text needs to be split to be able to choose the date you want.

Was this reply helpful? Yes No
JDsBuddy 36 on at

Like
a
(0)

Report
Copy link

Link copied!

I got it! At least I got something to work. Here's what I used ....

Split(
Concat(
Filter('Media', Title=Dropdown4.Selected.Result),
IssueDateAOF&";"
),
";"
)

Was this reply helpful? Yes No
JDsBuddy 36 on at

Like
a
(0)

Report
Copy link

Link copied!

I forgot I needed to sort, too. so the final formula I came up with that worked for all three was:

Sort(Split(Concat(Filter('Media',Title=Dropdown4.Selected.Result),IssueDateAOF&";"),";"),Descending)

Thanks for being here to help all of newbies!

Was this reply helpful? Yes No
JDsBuddy 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, I just found out Sort(Split(Concat(Filter('Media',Title=Dropdown4.Selected.Result),IssueDateAOF&";"),";"),Descending) didn't work for the Sort. I'm not getting any errors, so I don't know where I'm going wrong.

Thanks in advance for any help given!

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@JDsBuddy,

Why are you bothering the concat a table, then immediately split it out again?

Sort( Filter( 'Media', Title=Dropdown4.Selected.Result ), IssueDateAOF, Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
JDsBuddy 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response!

If I remove the concat, it doesn't work. With your formula, nothing displays in the drop down.

The last formula I put above does everything I need except for sorting the items.

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@JDsBuddy ,

Although I agree @WarrenBelz about split / concat in the same formula, if you are satisfied with it it's ok.

Your formula is not working because you forgot to reference the column based on which you want the data to be sorted.

So the correct form for your formula should be:

Sort( Split( Concat( Filter('Media',Title=Dropdown4.Selected.Result), IssueDateAOF&";" ), ";"), Result, Descending)

Hope it helps !

Was this reply helpful? Yes No
JDsBuddy 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah, that makes sense! This did work.

Thanks for all the help!

Was this reply helpful? Yes No