Restrict search based on current page

[gjayne1984]

Hi everyone

I currently have a Power Pages site setup that allows external users to search a single Dataverse table, which holds property details.  This all works fine using the built-in Dataverse search.

The table that is currently setup holds property information for a particular region but we now have plans to expand this functionality to include properties from other regions.  On the site we will have a separate 'landing' page for each region as visitors will normally only be interested in their region.  This also means that I now want to restrict the search based on which page they're searvhing from.

So for example if I click a link that takes me to the page on my site for Europe, when I do a search for a property I only want properties in Europe to appear in search results.  If for example there's a similar named property in North America I don't want that to appear.  Is there a way to do this?  I was thinking about having each region as a separate Dataverse table but if I do this I can't see a way of pre-filtering the search on each page in the site to only search the relevant table?

Any assistance would be welcomed.

[OliverRodrigues]

Hi, can you share a mock-up of what you are trying to achieve?

it seems to me that all you need is a list + form with subgrid 

[gjayne1984]

No problem, please see my very basic mockup below:

Current Setup

At the moment I have a single landing page with a search bar.  There is one Dataverse table on this site and the search/filters site setting:

As there is only one table being searched at the moment I've removed the filter dropdown from the search bar using custom CSS.  I don't want users to have to manually set this filter.

Proposed Setup

As we now need to add the ability to search for properties in other regions I was thinking of having a landing page that has buttons/links to take users to a separate page for each region:

There would then be a search bar on each page with text and information related to that region:

However, I don't know the best way to restrict the search on each of these region pages.  If possible I would want the filter dropdown to stay hidden but automatically change based on the page the user is on at the time?  I'm open to any other ideas though if that's not possible.

[OliverRodrigues]

Hi, you probably have a table called Regions or something, I would start this by using List component pointing to that table

Each region should have multiple Properties via 1:N relationship (this should probably be another table), have you designed this in the Dataverse? 

[gjayne1984]

I did use a list view originally but the search function wasn't the best as you needed to use wildcards and any columns you wanted to search needed to be in the list view, which was a bit cluttered?  I was wondering about using JavaScript to automatically set the Search filter dropdown based on the page the user was on i.e. if the user is on the Europe page the search filter on that page will default to the Europe table, but I'm not sure if that's possible?  This method is also why I was thinking about having individual tables for each region's properties as I assumed it would be easier to break out the search this way?

[OliverRodrigues]

would this article help with enhancing the search experience?: http://oliverrodrigues365.com/2022/12/14/power-pages-adding-wildcard-on-list-search/