cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AzJackson
Helper I
Helper I

Search Box and Display Form - No Gallery

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

6 REPLIES 6
eka24
Super User
Super User

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.

 

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.

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.

View solution in original post

Drrickryp
Super User
Super User

@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.

Thanks.

 

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

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,317)