Learn SharePoint In Series - Part Twenty Six - Task Outcome And External Data Column Type In SharePoint

Introduction

This article is the 26th part of my SharePoint series. Here are my previous articles.

1. Learn SharePoint In Series - Part One - Introduction
2. Learn SharePoint In Series - Part Two - Web Application
3. Learn SharePoint In Series - Part Three - Site Collections
4. Learn SharePoint In Series - Part Four - Subsites
5. Learn SharePoint In Series – Part Five – SharePoint Lists
6. Learn SharePoint In Series - Part Six - Power Of Versioning
7. Learn SharePoint In Series - Part Seven - Lists Advanced Settings
8. Learn SharePoint In Series - Part Eight - Validation Settings in List Settings
9. Learn SharePoint In Series - Part Nine - Audience Targeting
10. Learn SharePoint In Series - Part Ten - Rating Settings
11. Learn SharePoint In Series - Part Eleven - Form Settings in List Settings
12. Learn SharePoint In Series - Part Twelve- Save list as a template in List Setting
13. Learn SharePoint In Series - Part Thirteen- Permission Settings in List Settings
14. Learn SharePoint In Series - Part Fourteen- Enterprise Metadata and Keywords
15. Learn SharePoint In Series - Part Fifteen - Retention Policy Under Information Management
16. Learn SharePoint In Series - Part Sixteen - RSS Settings in List Setting
17. Learn SharePoint In Series - Part Seventeen - List Columns in SharePoint
18. Learn SharePoint In Series - Part Eighteen - Multiple Lines Of Text Column Type in SharePoint
19. Learn SharePoint In Series - Part Nineteen - Number and Choice Column Type in SharePoint
20. Learn SharePoint In Series - Part Twenty - Currency and Yes No Column types in SharePoint
21. Learn SharePoint In Series - Part Twenty One - Person or Group Column types in SharePoint
22. Learn SharePoint In Series - Part Twenty Two - Date and Time Column types in SharePoint
23. Learn SharePoint In Series – Part Twenty Three – Look Up Column Type in SharePoint
24. Learn SharePoint In Series - Part Twenty Four - Hyperlink or Picture Column Types in SharePoint
25. Learn SharePoint In Series -Part Twenty Five - Calculated Column in SharePoint

In the previous article, I have explained about calculated columns in SharePoint. We have seen how calculated columns will help us in maintaining the basic and advanced calculations in SharePoint. In this article, I am going to cover Task Outcome columns.

In this article, I am going to cover the following topics in detail.

• Introduction to Task Outcome columns
• Introduction to External Data columns
• Summary

Introduction to Task Outcome columns

While working with the task approval workflow, we have only 2 possible outcomes, Approve or Reject. But in many cases, we require custom outcomes like Approve, Pending, Reject, and Closed. If you want to add multiple outcomes to the task approval workflow you have to use the Task outcome column available in SharePoint. I will be explaining this in detail in my upcoming articles when we will be touching on the SharePoint Designer workflows.

For now, you can refer to the following articles to get the basic idea.

• How To Create Custom Task Outcomes In SharePoint 2013 Designer Workflow And How To Use It
• https://www.fmtconsultants.com/how-to-add-completed-or-in-progress-buttons-to-workflows/

Creating Task Outcome Column Type in SharePoint

You can select any of the ways while creating a list column as shown in this article. Just select the Task Outcome column type. When you select the Task Outcome column type, then you will have the following options to configure.

Now, refer to my article on the Choice column. Here also you have the same option.

So, here we saw that the options available in the Choice columns and Task Outcome columns are exactly identical except one. The “Allow ‘Fill-in’ Choice” column option is not available in the Task Outcome column while it is available in the Choice column. This option is not allowed in the Task Outcome column type as the value Task Outcome column is filled by SharePoint Designer Workflow.

Introduction to external data columns

Consider a scenario where you have migrated your business from On-Premises to SharePoint Online. Your On-Premises was based on SQL Server. You have certain data in SQL Server which are very large to move in SharePoint Online or SharePoint Server. And you want to use that information in SharePoint. So you want something that displays your SQL server data to SharePoint without importing that data in SharePoint. So for this, SharePoint provides a service named  “Business Data Connectivity” also well known as BDS. This can be configured by only Administrators. Once this connectivity service is configured, then we have to use special types of columns that will display the information from this BDC.

That column is called as External Data column. The name itself describes that it will contain data that is not in SharePoint and can be configured from BDS. For more details refer to the following image.

Image Source

Here you can see that SharePoint is fetching the data from External data and displaying it to the user in the browser.

There are several benefits and limitations of having external data in SharePoint. The benefit is the External data column does not require being connected every time. You can work on the columns and when you connect the external source, the data will be automatically updated. And limitation is that this column cannot be indexed.

The best resource on the internet to learn about the External Data column is Introduction to External Data.

Creating External Data column type in SharePoint

You can select any of the ways while creating a list column as shown in this article. Just select the External Data column type. When you select the External Data column type, then you will have the following options to configure.

Here it will ask to select the external content type, as this column data is associated with BCS (External Content Type Service). Practically, I will be demonstrating this column in the later article in this series when I will be explaining BCS in detail.

Summary

So in this article, I have explained about Task Outcome and External Data column type available in SharePoint. I have also provided the reference links from where you can get information about these column types. In the next article, I am going to cover Managed Metadata column types in detail with practical examples.

If you have any queries regarding anything, you can let me know in the comment section.