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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 305 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 155 Most Valuable Professional

Last 30 days Overall leaderboard