web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Exporting value from c...

Power Automate

Unanswered

Exporting value from choice field in Dataverse

(0) Share

Report

Report

Posted on by SunnyB

26

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

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No

Join the conversation