The shape data in Visio 2013 diagrams can be linked to many external data sources, and one of the most useful is a SharePoint List. However, the Shape Data rows have a smaller number of expected data types than the column types that are available in SharePoint. This article begins an exploration of the mapping of SharePoint list column types to Visio data types.
The Type cell of a Shape Data row defines the data type, which is a number from 0 to 7, that is stored in that row.
Data Type | Description |
0 | String |
1 | Fixed List |
2 | Number |
3 | Boolean |
4 | Variable List |
5 | Date or Time |
6 | Duration |
7 | Currency |
The Format cell can modify the display of Value, or can provide the option values for the two list types.
[Read more…] about Mapping SharePoint List Columns to Visio Shape Data Types