Sort prizes alphabetically by the name of the gift card, not the amount

[tagustin2020]

@RandyHayes 

Hello,

I have a gallery of prizes. I would like them to sort in alphabetical order, but as you can see they are alphabetizing by prize amount. I imagine the Split function might be the way forward on this, but I'm not sure how to do it so it works dynamically. I have quite a few prizes divided up by different shift parties. Could someone help me out?

To be clear, I would like them to sort like this:

$50 Amazon Gift Card

$50 Best Buy Gift Card

$25 Powell's Gift Card

etc.

Thank you.

[RandyHayes · Accepted solution]

@tagustin2020 

Hi again! 

Sure thing...do all the prizes start with a dollar value?  If so, then this formula can be used in place of the one you have:

DropColumns(
    SortByColumns(
        AddColumns(
            Filter('Holiday Party Prizes', Status="Available" && Party.Value=ddPartyChoice.Selected.Value),
            "prizeTitle", Match(Title, "[^$\d+]\D+").FullMatch
        ),
        "prizeTitle",
        Ascending
    ),
    "prizeTitle"
)

This uses a regular expression to get the text part of the Title and then it sorts by it.

Note, the added column is dropped because it is no longer needed.

I hope this is helpful for you. 🙂

[tagustin2020]

@RandyHayes 

Randy, you are very clever. Being a novice, I never would have figured this out on my own. Yes, all of the prizes start with a dollar amount. The formula you provided is working perfectly. Thank you very much! Teresa

[RandyHayes]

@tagustin2020 

No problem!  That's why you have a community to reach out to for help 😁