Skip Ribbon Commands
Skip to main content
Jennifer Mason > Posts > SharePoint 2010: Filtering a List Web Part by Selecting a Shape within a Visio Document
June 03
SharePoint 2010: Filtering a List Web Part by Selecting a Shape within a Visio Document

In this blog post I wanted to cover the concept of using a Visio Diagram shape to filter a SharePoint list. In my scenario, imagine that you have a Visio document that maps out a specific process. For each step in the process there are different documents that need to be referenced. We want to create a simple page that users can access to see the process and to locate the required documents for each step in the process.

 

To get started we will need to have 3 different components:

  1. A list within SharePoint that contains the information about the process step.
  2. A diagram in Visio that is linked to the SharePoint list.
  3. A SharePoint Document Library that has a lookup field that references items in the list used for step 1.

This Post Applies To:

 


Our 3 lists will be linked together based on the process information list. Our Process list is our primary list. The Visio document and the associated documents list will both link to items in the process list. This linking will provide us with a way to filter the data. We are able to create this connection using the lookup feature within SharePoint and the Visio features to connect a diagram to SharePoint list data.

For my Process list I have just created a simple custom SharePoint list. My list is based off of the Custom List template and uses the default Title Column and a multi-line column called Description.

For my Visio Diagram, I started with a simple diagram that outlines my process. A screenshot is provided below:

Once I had the diagram as I needed I selected the Data Ribbon so I could connect this diagram to an external data source (the list I created in step 1).

Selecting the Link Data to Shape opens a window that allows you to configure your data connection. In our example we are going to connect to the SharePoint list we created in step 1.

If you follow the wizard you will first need to select your SharePoint site and then you will need to select the specific list to connect to:

Now that our list items are displayed in data window, we will take each process item and associate it with a step in our process diagram.

We will need to repeat this step until all the shapes in the diagram are linked to the items in the SharePoint list.

 

Next we will need to create our library and add a column that links back to the same list of procedures that we linked the diagram to in the previous step. Here is a screenshot of the library. I have created one lookup column.

Now that we have the content configured we will be creating the display. For this I am going to create a page in the Site Pages library and then add two web parts to the page. Once both web parts are added, I will use a web part connection to pass data from the Visio Web Part to the Shared Documents web part.

For my Visio Web Part I will use the web part toolbar to configure the link to the published diagram and I will also set the properties to configure a custom height and width. Below are some screenshots of the configuration:

In addition to this, I need to configure the web part so it can use additional information in web part connections. In Visio when we added the connection to the list, we added the ID column to the shape data (this happened automatically as we linked the data shapes). We want to use this column as our connection so we need to configure the web part. This is done by adding ID to the tool pane option for exposing properties.

Once we complete the configuration and save the page you should see something similar to the screenshot below.

Next, I will add the document library we created in the steps above.

Now we just need to add a connection between the two web parts. This is done from the drop down menu of the Visio web part:

Then we will set the web part to Get Filter Values from:

And then we will need to connect ID from the Visio Diagram to the Process we linked to for the Associated Documents Library:

Once the configuration is in place, when you select a shape in the Visio Diagram it will filter the documents list to only show associated documents.

In this blog post we just looked at a simple example of linking content between a Visio diagram and different libraries. When you take this example and scale it out to larger business solutions you will be able to quickly see some of the benefits that are available by combining just a few out of the box tools! I'd love to hear about how you are using this type of solution, so please leave comments so we can see other examples!

 

Differences between Platforms:

The process for this is basically the same between the two platforms. Since Office 365 uses a different interface for adding web parts you will see some differences there, but those are minor. Examples of those can be found in this blog post. You will also notice that with Office 365 you will have some additional locations where you will be prompted for authentication to the site.

Comments

Very cool!

Thanks for writing this up in such detail with screenshots Jennifer.  I've only worked a little with shape data in Visio but this could be really helpful for many BA scenarios.
 on 6/5/2011 9:48 AM

Exiting

Exiting stuff..
 on 6/6/2011 11:46 PM

show all items

Hi Jennifer,

I've implemented a solution as you described, but when opening my page the list shows no items instead of all items.  I also want to have a shape in Visio which allows the user to see all the items in a list.


Best regards,
Pieter
 on 5/25/2012 10:18 AM

show all items

Hi Jennifer,

I've implemented a solution as you described, but when opening my page the list shows no items instead of all items.  I also want to have a shape in Visio which allows the user to see all the items in a list.


Best regards,
Pieter
 on 5/25/2012 10:27 AM

bridal shop

for you go shopping http://www.quedress.net/quinceanera-dress-function-occasion.html . The empire waist apparel assists to show away the chest location together with falls straight cutting which signifies you can hide only a tiny empire waist wedding dresses little of ones abdomen together with your hip location. http://www.quedress.net/ .  The trumpet design dress http://www.quedress.net/flower-girl-dress-function-occasion.html , assists to accentuate hips, especially for all these folks that dont have big ones. The trumpet style apparel will create a lady devoid of possessing curves start looking a complete wonderful present curvier.Also, making use of a prolonged evening dress, assure that you just obtain a pair of substantial heels http://www.quedress.net/bridesmaid-dress-function-occasion.html  http://www.quedress.net/bridesmaid-dress-function-occasion.html    . . everyone appears a great supply superior once they are taller. you can effectively even have to contemplate a pair of program heels on account of the reality most within the time your shoes will not show beneath your dress http://www.quedress.net/wedding-dress-function-occasion.html . . what ever your strategy kind, entirely    .
 on 6/15/2012 1:26 AM

tory burch boots

Type Stiletto Heel Heel Height 3 quot http://www.war-shoes.com/autumn-collection.html . quot. Shaft Height 16 quot.-18 quot.(Approx.40.64cm-45.72cm) Shaft Circumference 12 quot.-14 quot.(Approx.30.48cm-35.56cm) European Size 34, 35, 36   . , http://www.war-shoes.com/pumps.html  37, 38, http://www.war-shoes.com/ .  39 Available Width Average Select Color Black, Ivory Occasion Party amp. http://www.war-shoes.com/sandals.html  Evening, Special Occasion, Office amp. Career Season Fall, Winter Net weight 0.65 kg Shipping Weight 0.85 kg Tips Color amp. Style representation may vary by monitor. Not responsible for typographical or pictorial errors http://www.war-shoes.com/fashion-collection.html , Random Sole Color Category Women's Shoes Shoes Style Closed Toe, Boots, Knee High Boots Upper Materials Suede Lining Materials Suede Embellishment Lace-up Heel Type Stiletto Heel Heel Height 3 quot. quot. Shaft Height 14 quot. quot. Shaft Circumference 14 quot. quot. European Size 34, 35,   .  36, http://www.war-shoes.com/sandals.html .  37, 38, 39, 40, 41, 42, 43 Available Width Average Select Color Black, Brown, Yellow, Red, Gray Occasion Party amp. Evening, Special Occasion, Office amp. Career Season Fall, Winter Net weight 0.65 kg Shipping
 on 6/22/2012 2:47 AM

christian louboutins

 http://www.war-shoes.com/sales-promotion.html irritated about this rating. http://www.war-shoes.com/sales-promotion.html  You will find numerous teen flicks rated that way. The issue is the fact that going towards the films having a parent, particularly to get a 13yearold, won,t be cool   .  http://www.war-shoes.com/ . . Not merely that, http://www.war-shoes.com/autumn-collection.html .  but when children see this flick with their parents they might possibly be much less most most likely to talk about the issue of bullying than they would if they had observed the movie with out getting a parent.   .  Bullying at school could be a difficulty that impacts all of us. http://www.war-shoes.com/short-boots.html  Those children that are bullied at school are a lot much less most likely to total simultaneously as they could if they had not been bullied. School bullies happen to be identified to turn out to be a great deal much more most likely candidates for wrongdoing, and criminal actions http://www.war-shoes.com/tall-boots.html . Possibly society should
 on 6/22/2012 2:48 AM

impressions bridesmaid dresses

Leatherette Embellishment Rhinestone, Imitation Pearl Heel Type Stiletto Heel Heel Height 3 quot. quot. European Size 36, 37, http://www.suredress.net/Wedding-&-Print-Dress.html  38, 39, 40, 41 Available Width Average Select Color Ivory, White Occasion Bridal Shower, Wedding, Party amp. Evening http://www.suredress.net/Special-Occasions.html , Engagement Party Season Spring, Summer, Fall Net weight 0.65 kg Shipping Weight 1 kg Tips Color amp http://www.suredress.net/Wedding-&-Print-Dress.html . Style representation may vary by monitor. Not responsible for typographical or pictorial errors, Random Sole Color Category Women's Shoes Shoes Style Pumps, Peep Toe, Platform Upper Materials Satin Lining Materials Leatherette Embellishment Rhinestone, http://www.suredress.net/Cocktail-Dresses.html  Applique, Satin Flower Heel Type Stiletto Heel Heel Height 3 quot. quot. European Size 36, 37, 38, 39, 40, 41 Available Width Average Select Color Ivory, White Occasion Wedding, Party amp. Evening, Special Occasion Season Spring http://www.suredress.net/ . , Summer, Fall Net weight 0.65 kg Shipping Weight 1 kg Tips Color amp.   .  http://www.suredress.net/Wedding-&-Print-Dress.html .  Style representation may vary by monitor. Not responsible for typographical or pictorial errors,   .  Random
 on 6/22/2012 6:08 AM

prom dress 2012

 with eye-catching colors will also give formal evening dresses you the ability to create a long formal look. For example,   .  guava or bright Kelly green is sure to catch everyone's eye and look stunning in both short and flowing styles. http://www.carweddingdress.net/ .  And when you pick up dresses for your bridesmaids, you can also halter dresses offer empire waist wedding gowns them attractive colors, but it is better to give them something that will integrate easily into their current wardrobe. http://www.carweddingdress.net/accessories-shoes.html  http://www.carweddingdress.net/accessories-shoes.html  In the most important day in your life, http://www.carweddingdress.net/bridal-gowns.html .  http://www.carweddingdress.net/bridal-party.html  selecting own surprising wedding dress cocktail dresses cheap is such a pleasant thing.  After all, chooing a right sleeve for your discount bridal gown will actually promote you beauty of your shoulder and make it more sexy than you thought,   .  I promise! An Anatomy of your discount wedding gown- sleeves This read was really worthwhile, the information was absolutely great! Keep up the  http://www.carweddingdress.net/wedding-reception.html 
 on 7/14/2012 7:03 AM

brial gowns

let him take the photos that day.   .  And I changed my mind concerning the haircut. Why get rid of 1 of my ideal assets as I headed into my senior year. That asset snared me an impressive boyfriend for most of that year (I,ll call him Jerry). Jerry was a member of the cool crowd, a handsome http://www.carweddingdress.net/wedding-reception.html . , charming fellow having a reputation for fun http://www.carweddingdress.net/Headpieces.html . And, greatest of all, he was an older guy—already graduated and working full time. Jerry didn,t suit my personality incredibly well, in the least the personality I,d had for most of my high school years (i. http://www.carweddingdress.net/prom.html e. shy, quiet, studious) http://www.carweddingdress.net/accessories-jewelry.html . But what the hell. http://www.carweddingdress.net/prom.html  Just realizing I was dating Jerry caused my classmates to completely reevaluate their opinions of me   .  http://www.carweddingdress.net/ . . Suddenly I was complimented on my clothes daily by cheerleaders who had by no means spoken to me. I was
 on 7/14/2012 7:04 AM
1 - 10Next

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


Please enter your comments above.  If you would like a response directly, please be sure to include your name and email.

Name & Email *


Today's Date : *

Select a date from the calendar.

Attachments