Skip to content
  • Microsoft Power Platform
    • Microsoft Power Automate
    • Microsoft Power BI
    • Microsoft Power Apps
    • AI Builder
  • Microsoft 365 / Office 365
    • Microsoft SharePoint Online
    • Microsoft Teams
    • Microsoft Office Online
    • OneDrive for Business
    • Microsoft Forms
  • Microsoft Azure
  • Microsoft Dynamics 365
  • About
    • About the Author Pieter Veenstra
    • Contact SharePains today!
    • My Published Articles elsewhere…
    • Privacy Policy
  • Power Automate, the ultimate user guide!
  • Power Apps, the ultimate user guide
  • Share your pains today!
  • About the Author Pieter Veenstra
  • Contact SharePains today!
!New!
Filter Query in SharePoint Get Items in Power Automate 3 Ways to add a column to an array in Power Automate Patch any field type in a SharePoint list item using Power Apps Call flows from a model driven app Variables or Compose? Consider neither in Power Automate Your 1st lesson in Power Apps, in a few easy steps! Create new tabs in your Teams in Microsoft Teams using Power Automate Who can create new environments in the Power Platform How to handle leavers in Power Automate How to embed a canvas app in your model driven app Automatically re-enable flows that were suspended in Power Automate The target in the Launch function in Power Apps Create new group alert using Power Automate Delegation Warnings in Power Apps 1 Top tip: PowerPlatformLearn.com and master the Power Platform within no time
  • Facebook
  • Twitter
  • LinkedIn
  • GitHub
  • Reddit
SharePains by Pieter Veenstra
SharePains

SharePains by Pieter Veenstra

Office 365, Power Platform, SharePoint, Azure and Dynamics

  • Microsoft Power Platform
    • Microsoft Power Automate
    • Microsoft Power BI
    • Microsoft Power Apps
    • AI Builder
  • Microsoft 365 / Office 365
    • Microsoft SharePoint Online
    • Microsoft Teams
    • Microsoft Office Online
    • OneDrive for Business
    • Microsoft Forms
  • Microsoft Azure
  • Microsoft Dynamics 365
  • About
    • About the Author Pieter Veenstra
    • Contact SharePains today!
    • My Published Articles elsewhere…
    • Privacy Policy
Wednesday, January 20, 2021
  • Power Automate, the ultimate user guide!
  • Power Apps, the ultimate user guide
  • Share your pains today!
  • About the Author Pieter Veenstra
  • Contact SharePains today!

SharePains Home | Microsoft 365 | SharePoint 2016 – Aaah, SharePoint Designer workflows!

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

SharePoint 2016 - Aaah, SharePoint Designer workflows! 1

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:

https://sharepoint.stackexchange.com/questions/156579/get-metadata-column-value-in-spd-workflow

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:

SharePoint 2016 - Aaah, SharePoint Designer workflows! 2

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

SharePoint 2016 - Aaah, SharePoint Designer workflows! 3

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

SharePoint 2016 - Aaah, SharePoint Designer workflows! 4

SharePoint 2016 – Aaah, SharePoint Designer workflows!

 

 

 

Share this:

  • Tweet
  • WhatsApp
  • Email

Like this:

Like Loading...

Related

Post navigation

Microsoft Forms – Quizzes the full starters guide, create a quiz
Microsoft Forms – Reports and quizzes, the full starter guide

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Looking for a different post?
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,622 other subscribers

Links
  • hybrIT Services HybrIT Services, this is where I work HybrIT Services, this is where I work
  • Microsoft Flow and PowerApps User Group Milton Keynes Join the UK Microsoft Flow and PowerApps User Group Milton Keynes Join the UK Microsoft Flow and PowerApps User Group Milton Keynes
  • ULS Monitor Monitor your SharePoint logs and see the issues before users do. Monitor your SharePoint logs and see the issues before users do.
  • Collab 365 today Get the latest news from over 365 blogs Get the latest news from over 365 blogs
  • Community Connect Are you looking for speakers or local technology experts? Are you looking for speakers or local technology experts?
Top posts
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
SharePains Privacy Policy
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: