Search in gallery with multiple fields

[gennarodp]

Hello, 

i have a powerapp with a Gallery of a sharepoint list.

This gallery has the following fields:

Work Center

Date

Title

The "Item" setting of gallery is the following formula:

SortByColumns(Filter([@'Test'], StartsWith('Title', TextSearchBox1.Text)), "Title"; If(SortDescending1, Descending, Ascending))

I would like to have the possibility to search fields with a TexSearchBox, not only with Title, but also with Work Center Value, and with IconSortUpDown to order those fields in order of Date Value.

How can i do this ?

Thank you all

[Drrickryp · Accepted solution]

Hi @gennarodp 

SortByColumns(
    Filter(
        [@'Test'],
        StartsWith(
            Title,
            TextSearchBox1.Text
        ) || StartsWith(
            'Work Center',
            TextSearchBox1.Text
        )
    ),
    "Date",
    If(
        SortDescending1,
        Descending,
        Ascending
    )
)

Unless I am mistaken, in your formula above, there should be a "," after "Title" not a semicolon before the If( .

Also FYI, Date is a reserved word and can cause ambiguities.  You should name your column in SharePoint something else like "DateEntered"

[gennarodp]

Yes, there is ",", my mistake.

Your formula doesn't work 😞

[Drrickryp]

@gennarodp 

Please post the error you are getting. or a screenshot showing it. If it doesn't work, I'm guessing you have the column name wrong in one of the StartsWith() functions.  If that is the case, let SmartSense help by suggesting the column name you want to use in the filter.

[gennarodp]

The problem is the field Date. Really it is in format date time.

[gennarodp]

Thank you very much @Drrickryp.

Happy new year

[Drrickryp]

Stay safe and be well!

[gennarodp]

Thank you. Have you news for NFC compatibility for powerapps ?