My Pains = Your Solutions

Office 365

SharePoint 2016 – Aaah, SharePoint Designer workflows!

Over the last year or so I’ve only really looked at the bleeding edge technology released by Microsoft. Microsoft Teams, Microsoft Forms, SharePoint Online, PowerApps and Microsoft Flow  and anything related have been very interesting.

Just before the 2017 year ends however I’m now working on a SharePoint 2016 project and it’s quite a challenge to go back to technology like SharePoint Designer workflows. Today one of those small problems that can be a bit of a challenge is to get the value of a Managed Metadata column.

I first went down the root of simply setting a variable to my column

But I bumped quite quickly into the following error as I was setting a string variable to the value of the Managed Metadata column:

Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.InvalidCastException: The value ‘d/results(0)/Location’ cannot be read as type ‘String’. at Microsoft.Activities.GetDynamicValueProperty`1.CheckedRead(String propertyName, DynamicItem value) at Microsoft.Activities.GetDynamicValueProperty`1.Execute(CodeActivityContext context) at System.Activities.CodeActivity`1.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager) at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Quite quickly I now found:

So I went throguh these steps:

  1. Choose action – set variable to value

  2. In the value section (popup when you click value)- choose the data source as the list which you are fetching the column from –

  3. In the field from source – choose the managed metadata column internal name

  4. In the find in the list item section – choose the field tp be ID and value to be CurrentItem -> ID (should look like CurrentItem.ID)

  5. Click on OK. This should get you value of the managed metadata column.

  6. If you want, you can use the action Log item to the history list to check the value.


So I change my set variable step into something like this: where I selected my Location column again:

But still no luck. Then I tried the Location_0 column, Huh what is this. My internal name of the column is definitely Location and not Location_0

Then I simplified my step again and the Location_0 column did the trick again.

SharePoint 2016 – Aaah, SharePoint Designer workflows!





Please leave a comment or feedback

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Fausto Capellan, Jr

Office 365, SharePoint, Azure and other things

Serge Luca's Blog (SharePoint & Office 365 MVP)

Sharepoint 20xx and Office 365 adventures

Hans Brender's Blog

IT News zu OneDrive, OneDrive for Business, Migration


Become a more productive technologist.

Legal Tech Talent Network

Talent Network for eDiscovery, Cybersecurity, Big Data, Forensics


Getting the latest tech news to you!

Ruben van Putten

I want to share my experiences with PowerApps, Flow and SharePoint

Title (Required)

Windows Server Essentials Tips & Tricks

Tech Gang

Quick Walkthroughs in SharePoint, Office 365, Azure, PowerShell, .NET and much more !

Tell IT as IT is

Small & big business IT - with a focus on Microsoft's solutions

CCPS Tech News

One-stop shop for news, tips & tricks!

Everything Cloud

My notebook about everything related to Cloud Computing and Security

Scott Croucher

Cloud Architect/Consultant

Bit Sized Bytes by Tad Yoke

Little bits of the big cloud picture


           In horizons of Software Architecture, Consultancy and Evangelism

Prasad Pathak's Technology Blog

Microsoft Technology Blog


"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." – Bill Gates

Steve's Tech Blog

Technical Tidbits of Interest and Musing

pickettsproblems's Blog

4 out of 5 dentists recommend this site

Simon's space

Blog thoughts and other musings

Steve Simpson, Glendale College Computer Instructor

Designed For My Students, Friends and Family!

Experience Microsoft Technology

Sharing makes you expert


Sharing The Knowledge

SharePoint Factory

Office 365, SharePoint and Project Specialists

Albert Hoitingh's Blog

Office 365 | Information management and protection | Security and compliance

Steve Harwood's - Microsoft Cloud Blog

Technology blog... primarily Microsoft focused with a smattering of other technology and the occasional personal interests :-)

MLD - Boston, MA

Golf Enthusiast, Technology Evalengist, Boston Sports Fan

Nathan Wells

SharePoint | Office 365

Dynamics 365 and Angular Developer based in Australia

Kurt Shintaku's Blog

Information about Microsoft for my Enterprise customers in Los Angeles.

that's alex

Gedanken des Alltags


by Satish Gadekar


Communication > Collaboration > Productivity.

Philip Calvert - Social Media Speaker

“If You're Not Virtual, You're Not Real"

Welcome to my SysAdmin site

TNT Computers of Long Island

Long Island Computer Service and Repair - IT support for your business and computer repair for home computers

%d bloggers like this: