web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Search Box and Display...
Power Apps
Answered

Search Box and Display Form - No Gallery

(0) ShareShare
ReportReport
Posted on by 39

Hi,

 

So I am trying to build a search function without gallery attached to it, is this possible.

 

1.  What I would like to do is have a search box (user enter lets say car reg for example) search box looks the data up from a sharepoint list and loads the details in a Display Form, therefore eliminating the need to have a gallery (have done this no issues with gallery but would like to get rid of the gallery if I can).  Is this possible? 

 

2. On a separate note, is it possible to link 1 gallery to multiple SharePoint lists if so how?

 

Thanks for any advise in advance.

Categories:
  • eka24 Profile Picture
    20,925 on at

    I think wat you need is a lookup instead of Search.

    So for intance to display the CarName in a textbox on your form, if the user types the CarReg, then the CarName will be displayed?

     

    If so, in the Default of the CarName textbox on your form:

    LookUp(Datasource, CarReg=TextBoxForSearch,CarName)

     

    Whatever the user types as the registration, if it matches the CarReg, the CarName will be displayed

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

     

  • AzJackson Profile Picture
    39 on at

    Uh yes, however I would need the form to display all the other fields in the row associated with the selected car reg as well, no just the one field.

  • Verified answer
    eka24 Profile Picture
    20,925 on at

    So replicate same formula for other fields as well:

    LookUp(Datasource, CarReg=TextBoxForSearch,DateofReg)

     

    LookUp(Datasource, CarReg=TextBoxForSearch,TotalPassengers)

     

    To improve performance, you can create a Collection OnVisible of the Screen:

    ClearColect(MyCars,Datasource)

    Then replace the Datasource in the Lookup with the Collection like:

    LookUp(MyCars, CarReg=TextBoxForSearch,DateofReg)

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @AzJackson 

    It sounds like a good application of a combobox with multiple search fields. Once one a record is selected you could simply add labels as Combobox1.Selected.field1, etc.

  • AzJackson Profile Picture
    39 on at

    Thanks.

     

    Is there anyway to link more than one SharePoint List to 1 gallery

  • eka24 Profile Picture
    20,925 on at

    Yes. One possibility is to combine the tables into one table.

    That is pull some columns from one table to another if the have a common column between the 2 tables.

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 139

Last 30 days Overall leaderboard