I have a top-level site with multiple sub-sites in a site collection in O365. All subsites have the same list named "Participants". This list has a column named "Status" which is a choice field of "Interested", "Invested" or "Committed". I want to use a Highlighted Web Part on the top-level site to roll-up content from all Participants lists based off of three different views from the Status field. How do I do this?
In using a "Custom query" and flagging the Source as "All sites", I am able to pull some information by using the Query text (KQL) "Title:Participants". This pulls some data, but not the right data. When I combine other parameters to the query, such as:
Title:Participants
Status=Committed
Then the query blows up. What I am looking to get are the individual contents of each Participants list based off the Status field designation. Is this possible?
