I have a SharePoint Designer site workflow in SharePoint 2013 (Online) that I'm using to loop through a list, and collect properties from each item using the REST API. One of the columns I'm looking at is contains a date and time, and the JSON value returned by the API is ISO-formatted, like this:
When I try to set a
Date/Time variable to this value I get the following error and the workflow is suspended:
The conversion could not be completed because the supplied DateTime did not have the Kind property set correctly. For example, when the Kind property is DateTimeKind.Local, the source time zone must be TimeZoneInfo.Local
Is this kind of conversion actually possible in a SharePoint 2013 workflow? This article suggests it can be done with a SharePoint 2010 workflow, but that doesn't mean that Microsoft didn't remove the feature from 2013 workflows, as it did with many others.
If it's not possible then my fallback is to retrieve the
Id property from the API response, then look up the date using the
Set workflow variable action, however, since I've already retrieved the data from the API, I'd rather use that if I can.