How to update Choice field from crm record to sharepoint

[nz1]

When I'm lost I always come to the community for help 😄 so here we go 

Imagine you have a table - in that table you have a choice field - in that choice field you have a few options i.e 1,2,3,4 

You have put that field in a main form and make it available in modern driven app. 

What I'm trying to achieve

 I'm configuring a flow that will update sharepoint file properties based on the values from CRM record. For example i grab the title of the record  and update the title column in sharepoint. But now i need to update a choice field  from crm to a field i setup in sharepoint. for example: I create a crm record with the choice field - when i select the choice field (i can select an option i.e 1) i save the record - i would like to grab that value from the record and save it to to the SharePoint field i created.  For all the other fields i have been using the 'update file properties' connecter with no issues for example inside the item section ill put down "nameofcolumproperty":"CRM field", and that will update what ever value i had from crm record to the sharepoint colum but I'm stuck when it comes to choices or options sets as the data changes based on the choice. 

Hopefully the above makes sense. 

Basically updating crm choice value to sharepoint colum 

[v-jefferni · Accepted solution]

Hi @nz1 ,

Could you please share more details about your scenario? What type is this column in the SharePoint library? Does it a Choice column include all the same choices as those in the Option sets?

If it is a Choice column in the library, then you could simply use the custom dynamic content to populate the Choice column based on the selected option set value in the Dataverse table:

Status is a common option set, which is using in many tables. I just take it as the example.

Best regards,