Open the settings menu and click on Add an app;
On the search box type BT;
- Look for the Filters list and open it;
Pick a name for the app and click on Create;
You've created the list that will contain all the specific fields from this web part.
- Open the list that you have created, and copy the list URL, you will need it to connect the list to the web part.
Templates List URL
This is the place to paste the URL to the Templates list. This is where you have all your templates which define how content from the SharePoint list will be presented. Without this value, the web part cannot function and an error message will be displayed requesting that you connect the web part to a templates list.
Paste the URL saved on the step above on the section Templates List Url.
Data Source URL
Use the Data Source URL field to map the data from an external data source, typically a SharePoint List. Paste the URL of the list that you intend to show information on. Without this value, the web part cannot function and an error message will be displayed requesting that you connect the web part to a source list.
The Data Source URL is where your information will be pulled from to display on the Web Part.
You can query the list to just show items based on the query built.
You can use a free 3rd party software for creating the query, like this one👉http://www.u2u.be/software/. Then you can copy the query and use it as a filter. Below is an example with multiple filters allowed of a query you can have.
If you’re using SharePoint 2013, install the U2U CAML Query Builder for SharePoint 2013 (Standalone Edition).
<View> <Query> <Where> <And>// have to meet this 2 conditions <Eq> //Equal <FieldRef Name='PromotedState' /> <Value Type='Number'>2</Value> </Eq> <Leq> //Lower or Equal <FieldRef Name="Created" /> <Value Type="DateTime" Offset="-90"> // -90 days from today <Today /> </Value> </Leq> </And> </Where> <OrderBy> <FieldRef Name='Created' Ascending='False'></FieldRef> // Most Recent to older created element </OrderBy> </Query> <RowLimit>3</RowLimit> // Number of items that you want to show </View>
It is recommended that you use relative paths in this field. So instead of using a URL like https://company.sharepoint.com/sites/Home/Lists/Filters you should use something like /sites/Home/Lists/Filters. This will ensure that the web part will work regardless of how you’re accessing the site.