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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 101 Most Valuable Professional
Haque 81
VASANTH KUMAR BALMADI 70
