web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / TIME CRITICAL Getting ...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 6

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. 

Jana_St_0-1676474225464.png

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

Jana_St_2-1676474563584.png

 

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.'.

 

 

Categories:
I have the same question (0)
  • jana_stefanskaja Profile Picture
    6 on at

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard