Share via

PowerApps Search function

Anonymous
2022-08-17T13:10:58+00:00

In my App I need to develop my search in the gallery

my gallery is based on an Excell data base' and I design the gallery that chooses for the user according to the search box

I want to add another search box and the gallery chooses the items that have both what is written in the tow search boxes

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-08-18T05:21:21+00:00

    Dear Hanan,

    I'm following up on the thread.

    Generally, you can connect the gallery control to the Excel Online table such as Table1 and create a text box TextInput1 as a search box and type the following formula to search the Excel items based on a column such as Column1.

    Search(Table1,TextInput1,"Column1")

    I guess that you want to add a second search box TextInput2 and search the Excel items based on another column such as Column2 in the same gallery.

    If yes, you can use the following formula to see the result.

    Search(Search(Table1,TextInput1.Text,"Column1"),TextInput2.Text,"Column2")

    Welcome to share any updates when you have time if you need further help on this issue.

    Sincerely,

    Cliff | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-17T14:26:54+00:00

    Dear Hanan,

    Good day! Thank you for posting in Microsoft Community. We are happy to help you.

    From description, you want to add another PowerApps search box in the gallery.

    We'd like to help you. Please allow us some time to do tests in PowerApps from our side and try to look for possible solution. We will post back as soon as we get any update.

    Thanks for your patience and understanding! Hope you keep safe and healthy always.

    Sincerely,

    Tina | Microsoft Community Moderator

    0 comments