cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerwood
Helper II
Helper II

Dataverse Choice Column in Excel via Odata

I am using Dataverse table in Excel through the Odata connection. One of the columns (Project State) is a Choice column in Dataverse which shows the ID (twelve digit number) of the choice item rather than the label ("NY"). 

 

I need to use the label rather than the ID. I tried to load the choice column as a separate Odata table, but that does not seem to be an option. I'm sure I could make a simple table linking the ID to the value, but I have this situation elsewhere and would like to resolve it in a way that does not cause me to create a separate table manually.

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User II
Super User II

Hi @powerwood,

That's the default behavior with the standard OData connection since choice columns are stored as integer values in the tables. Have you tried using the Power Apps Office/Excel add-in? It's pretty good and allows you to select directly the label instead of the values. To open it, in make.powerapps.com, navigate to Data -> Tables -> select your table then click the "Edit data in Excel" button. The excel will download, once opened the add-in will appear on the right, login in with the same credentials if it ask you.

 

More info on the add-in: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-excel-addin

Hope this helps!

View solution in original post

1 REPLY 1
EricRegnier
Super User II
Super User II

Hi @powerwood,

That's the default behavior with the standard OData connection since choice columns are stored as integer values in the tables. Have you tried using the Power Apps Office/Excel add-in? It's pretty good and allows you to select directly the label instead of the values. To open it, in make.powerapps.com, navigate to Data -> Tables -> select your table then click the "Edit data in Excel" button. The excel will download, once opened the add-in will appear on the right, login in with the same credentials if it ask you.

 

More info on the add-in: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-excel-addin

Hope this helps!

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,133)