cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CindyZ
Post Partisan
Post Partisan

Filter parent and child lists from one search combobox

I have two lists that are geographical locations.  One is the parent list and the other a child list.  They are tied together via the parent ID.  

 

I'd like people to be able to select a state, for instance, and have it filter through all locations in the parent and the child site and return the results BUT direct the user to contact the parent site.  

No doubt, there is a formal name for what I'm trying to do but I have no idea what it is or how to even clearly explain it.  So, I'm including some examples that I hope will help. 

 

I need to be pointed in the right direction as the best way to accomplish this.  Right now, my search works perfectly fine searching on the parent list -- but we've now added children and want to direct people to the parent -- if there is a parent.  

Thanks in advance for your consideration and guidance on how to approach this.  

 

Example of Parent and Child Records - Results to be returned.png

 



5 REPLIES 5
BoHamad
Helper I
Helper I

Forget what i wrote all wrong

StalinPonnusamy
Super User
Super User

Hi @CindyZ 

 

Please share a piece of information to help with this.

 

  1. What data source like SharePoint, SQL or Datacerse
  2. Can you explain "Direct the user"? Do you want to navigate to another screen or Sharepoint list item?

 


Thanks,
Stalin - Learn To Illuminate

Absolutely, and thank you.   

 

This is SharePoint. 

 

I would want them to be able to click somewhere (Probably on the parent record - gray)  that would then take them to a screen that would show the details for the parent -- or for that matter in a gallery beside the returned

results.  

Hi @CindyZ 

 

Set the Onselect property of the button or link to

If(!IsBlank(ThisItem.ParentID),Set(varParentId, ThisItem.ParentID); ViewForm(EditForm1); Navigate(EditScreen1))

 

On the Edit Form Set the item property of the form to

LookUp(SPListParent, ID=varParentId)


Thanks,
Stalin - Learn To Illuminate

 

Thanks, StalinPonnusamy,  I think what I'm still  missing is how to get that child content to be a part of the search.  

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,604)