Notifications
Announcements
Dear Experts,
Why my Dataverse choice column data is added as (number or ID) into the Excel?
I expect the output is my choices' names: Serial, Batch, N/A
My flow is as such:
Dear @JAWL
Hope you are doing good.
May i know how you prepared the excel. Did you export from Dataverse.
Note: For Microsoft Flow we need Optionset Value to proceed the same
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
Hi @rampprakash , I did not export from Dataverse to Excel. Just use Add rows to Excel in Power Automate.
Hi @JAWL ,
You are grabbing the value if you reference the Choice field like you did.
When you run the flow, look at the output of the prior step and you will see something like this for the Choice label vs. the Choice value:
The trick on the export in flow is you need to grab the "label" vs. the value. I did this in my example in a next step to set a String variable by doing the following to get the label value:
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268
