
Hello,
Im trying to export data from Dataverse to a Sharepoint list and this seems to be work fine. However i notice for fields which are of type "Choice" the exported value is a number e.g 597910009 instead of the actual text value.
How can I get the actual value instead of this id/enum?
Thanks
Hi @SunnyB
The issue is that you need to format the "Choice" value in a specific way so that SharePoint can link it correctly.
I explain a similar issue when data comes from Microsoft Forms, but the concept is the same. It would be best if you created the value in a variable with the format:
[
{
"Value": "Option 1"
},
{
"Value": "Option 3"
}
]
After this, SharePoint will recognize the options and add them correctly for you.
Can you please check if and let me know if you have any questions?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel