Forum Discussion
Highlighted content web part
I think you are on the right track. One way to do this is to use managed metadata for the values. You can create a term set at the root of the tenant and then in each site collection, create a column (type=managed metadata) that maps to the term set. Then, also at the root, map the local columns to an available existing managed property - RefinableStringxx. Once you do that, you can select the sites that you want to use in your roll-up and use a Highlighted Content web part to filter for RefinableStringxx contains [value]. A few things to note: you may need to wait for the search index to run for everything to sync up and you need to actually assign values to content in the individual sites before all of this will work. In other words, you can set it all up first but then you have to add content and assign the metadata for the index to pick everything up and the roll up to work. You can find more information about mapping columns in this article about managing the search schema.
I think you are on the right track. One way to do this is to use managed metadata for the values. You can create a term set at the root of the tenant and then in each site collection, create a column (type=managed metadata) that maps to the term set. Then, also at the root, map the local columns to an available existing managed property - RefinableStringxx. Once you do that, you can select the sites that you want to use in your roll-up and use a Highlighted Content web part to filter for RefinableStringxx contains [value]. A few things to note: you may need to wait for the search index to run for everything to sync up and you need to actually assign values to content in the individual sites before all of this will work. In other words, you can set it all up first but then you have to add content and assign the metadata for the index to pick everything up and the roll up to work. You can find more information about mapping columns in this article about managing the search schema.