TIME CRITICAL Getting choice values from Sharepoint List and set option set value in Dynamics 365

(0) Share

Report

Posted on by jana_stefanskaja

Hello guys,

I am creating a flow when SP list record was created -> to create Dynamics 365 record. I am struggling with getting choices from SharePoint choices and set them as option set in Dynamics 365 CRM.

Example: I have choice field in SP called Incident Type. Which is: Injury, Incident, Near Miss. In Dynamics 365 CRM I have same values. To set a value in CRM I will need to do a mapping. I`ve implemented same thing with Microsoft Forms and this is an example, which I was trying to use with SP -> CRM.

But for some reason, when I am using the same method in a new flow, I am getting error:

Unable to process template language expressions in action 'Select' inputs at line '0' and column '0': 'The template language function 'json' parameter is not valid. The provided value 'Injury' cannot be parsed: 'Unexpected end when reading JSON. Path '', line 1, position 6.'. Please see https://aka.ms/logicexpressions#json for usage details.'.

All responses (1)

Answers (0)

jana_stefanskaja 6 on at

Like (0)

Report

Re: TIME CRITICAL Getting choice values from Sharepoint List and set option set value in Dynamics 365

Additional details, which i get as json:

"body":{
"@odata.etag":"\"1\"",
"ItemInternalId":"15",
"ID":15,
"Title":"222222",
"IncidentType":{
"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id":0,
"Value":"Injury"
},
"IncidentType#Id":0,