Power App - Gallery Search, sort by and assigned to

[FatimaS]

Hello,

I have a question regards the power app joining more than two codes (search, assigned to and sort A to Z).

I have created a gallery in the power app and under items I want only the assigned work to that specific staff to be shown while the staff is using the app (should not see other staff assigned work and there is an assigned work column in the table). Plus, users can search by a specific thing (country code for example) and sort the gallery from A to Z.

I tried using the below code, but I cannot get any result (error).

Filter(Search(TableBSP,Assigned To = User().FullName, txtSearchBox1.Text, "CountryCode")

TableBSP - Source Table (OneDrive)
txtSerach - search box name
Assigned To - column in which work is assigned to multiply users in the source table (name is already conducted to MS365)

Appreciate it if you could guide me on how to make this work. Thank you.

Best Regards,

[v-bofeng-msft]

Hi @FatimaS ,

Could you please tell me what assigned to column's type is? Is it a text column?

I assume assigned to is a text type column , Please try:

Filter(Search(TableBSP,txtSearchBox1.Text, "CountryCode"),'Assigned To' = User().FullName)

Best Regards,

Bof

[FatimaS]

Hello Bof,

Thank you for your response.

Yes, it's a text column. Note that I am trying to search from a gallery.

I tried your code, and it shows the assigned work to the staff only, whereas when I am trying to search by specific country, no result is showing even though that country is available in my assigned work.

Regards,

Fatima

[v-bofeng-msft]

Hi @FatimaS ,

Could you please provide some screenshots? Is 'CountryCode' a number column or text column?

Maybe you could try:

Filter(
    TableBSP,
    txtSearchBox1.Text in CountryCode && 'Assigned To' = User().FullName
)

Best Regards,
Bof

[FatimaS]

Hello Bof,

CountryCode is a txt:

I tried the above code provided by you and it does not work.

Regards,

Fatima

[AARON_C]

Hi @FatimaS,

Please try this:

Sort(
    Search(
        Filter(
            'Data Source', 
            'Assigned To' = User().FullName
        ), 
        txtSearchBox1.Text, 
        "CountryCode"  
        // If using DataVerse you may need to include the publisher prefix 
        // E.g "cr034_countrycode"
    ),
    'Column you want to sort', 
    SortOrder.Ascending
)

Please tick Accept as solution if the answer is useful.

Thanks,

@AARON_C 

[FatimaS]

Hello @AARON_C ,

Its correct, but search it does not. I do not why, I tried multiply codes, but with same result.

Thank you for your response.

Regards,

Fatima

[AARON_C]

Is your text input control you are using to search called txtSearchBox1 or txtSerach?

Please make sure you are using the correct name as you have used another name in the formula you first provided.

[FatimaS]

I renamed it only.

[AARON_C]

Does the search functionality now work?