Create a list
This list is what you will use to store your Tiles.
Let's create your list:
Click on Settings ⚙️ and then on Add an app;
On the search box type BT, look for the Tiles BT and click;
Name the list and click Create. List created;
Here you will need to connect your web part with a SharePoint list. Without it, the web part will not function and an notification message will appear. Let's get to it:
On Tiles List, click Add List
On the first text box insert one of the two:
- The URL of the list you created
- A URL of a site collection
Use relative paths for this field. So instead of using an URL like https://company.sharepoint.com/sites/Home, you should use something like /sites/Home/.
Second box, select the list you have created to be used if not already selected;
Choose your Filtering Options to filter your list elements. You can choose to have:
- No Filters - You show all the items on the list.
- CAML Query - You can query the list to just show items based on the query built.
- Select a View of the list - You can pick the List View created and just show those elements on the list.
When you're done, click on the 💾(save) icon to save.
How to use CAML Query
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>