Home >Tips >SharePoint Online Exercises >Click to filter connected app parts kalmstrom.com site map icon Site map  

Click to Filter with Connected App Parts

A SharePoint Online Exercise by Peter Kalmström

SharePoint iconWhen you create a list or library in a SharePoint site, it will automatically be available as an app part that can be inserted in a wiki or web part page. In the demo below demo Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, shows a way to connect app parts to let users select a country and see all customers from that country.

For this to work you need two Excel tables: one table with customer details and one with just the country column from the customer table. The task has three steps: export from Excel, create a wiki page with app parts and connect the app parts.

Export Excel tables to SharePoint

Excel icon
  1. Format the data as a table. Note that this is only possible if there are no blank rows or columns among the data.
  2. Click on the Export button under the Design tab and select 'Export Table to SharePoint List'.
  3. Enter the URL to the SharePoint site where you want to import the Excel table.
  4. Check the box for read-only connection.
  5. Enter a name for the new SharePoint list.
  6. Click Next and then Finish.
Now a new SharePoint list will be created on the site you gave the URL to, and the data from the Excel table will be distributed into it. This list has a default datasheet view, so you have to create a new standard view and set it as default.

Create a wiki page and add app parts

  1. In the Site Contents, Open the Site Pages library and click on New. Select 'Wiki page'.
  2. Give the page a name and click on Create. The new page opens in Edit mode.
  3. Click on the Text Layout button under the FORMAT TEXT tab and select two columns.
  4. Place the mouse cursor where you want the Countries list to be displayed and click on the App Part button under the INSERT tab.
  5. Select the Countries list and click on Add.
  6. Place the mouse cursor where you want the Customers list to be displayed and click on the App Part button under the INSERT tab.
  7. Select the Customers list in and click on Add.

Connect the app parts to show filter choices by clicking

  1. Expand the accordion in the top right corner of Countries list app part and select Connections >Send Row of Data To >Customers.
  2. In the pop-up dialog, select 'Get Filter Values From'.
  3. Click on Configure.
  4. Connect the Country field in the Provider to the Country field in the Consumer.
  5. Click on Finish and then Apply and save the page.
Now users can click on the icon to the left of the country, and only customers from that country will be displayed.

Follow kalmstrom.com on LinkedInFacebook or Twitter!

back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved