Apr 27 2021 06:56 AM
Hi! I have five different lists that track different products. I just want a single view to look at that will show me all INCOMPLETE status entries across all five lists so I know what needs to be worked on. Is this possible?
Apr 27 2021 07:27 AM
@chanpion13 This is not possible using default List web part.
If you have used a site column (specifically to use managed property) for your status column which indicates completed/incomplete list items, you can achieve this using Highlighted content web part by specifying the necessary filters using managed property.
Else, you have to develop a custom solution using SharePoint Framework.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Apr 27 2021 09:32 AM
@chanpion13 you can build this out-of-the-box in Power Apps without needing to use an SPFx framework (which at my company is not allowed anyway).
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Apr 27 2021 01:55 PM
Apr 28 2021 12:59 AM
@chanpion13 Highlighted content web part uses KQL for custom filter queries. So you can use KQL queries to return the list items from specific SharePoint lists or all lists.
To get items from specific lists, you can use query like:
Path:"https://siteUrl/Lists/List1" Path:"https://siteUrl/Lists/List2" Path:"https://siteUrl/Lists/List3" contentclass:STS_ListItem
To get items from all SharePoint lists (& to exclude documents) use query like:
contentclass:STS_ListItem
You can also add additional filters based on managed properties as per your requirements. Also, check below documentation related to KQL:
Keyword Query Language (KQL) syntax reference
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Apr 28 2021 09:02 AM
Apr 28 2021 11:52 PM
@chanpion13 You can only use either one.
You can use Filter with managed properties by selecting them from dropdown or you can use Custom query & define filters using KQL
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Feb 07 2022 01:01 PM
@RobElliott any suggestions on where to look for a walkthrough on how to do this with Power Apps?