Answered

How to get values of choice column in power pages using JS or html?

(0) Share

Report

Posted on by rbn_neu

Hi Folks,

I'm building a power pages site completely using html, CSS and JS. I'm not using forms or views. I have a pop up with few checkboxes inside it in a web page. The code is in the html of the page. I have a dataverse multi select choice column in a table. I want to retrieve the label and value for all options in this choice column and use it as label for all checkboxes. And when I save it back I need the values to be used.

But I'm unable to find any working methods of retrieving choice column values. I tried power pages API (entity definitions) and liquid code (entities.tableName0 both did not wokr.

Any thoughts?

Thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rbn_neu

For this you have to call the Dataverse web api as such

Make sure that where I said v9.x that you use .1 or .2 depending on your version. Its most likely .2 but just to be safe.

GET https://EnterYourOrgNamehere.crm.dynamics.com/api/data/v9.x/EntityDefinitions(LogicalName='entitylogicalnamegoeshere')/Attributes(LogicalName='columnlogicalnamehere')/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=OptionSet

Now you need to use this in your javascript

NOTE I had to put in carriage returns because its too long just connect it back together If you need help showing it in your html let us know, otherwise you will use your optionData to build your dynamic HTML. async function retrieveMyChoiceLabelsEtc() { const response = await fetch ("/_api/data/v9.x/EntityDefinitions(LogicalName='entitylogicalname') /Attributes(LogicalName='columnlogicalname') /Microsoft.Dynamics.CRM.PicklistAttributeMetadata? $select=OptionSet", { headers: { "Accept": "application/json" } }); const returnedData = await response.json(); const optionData = returnedData.OptionSet.Options.map(opt => ({ value: optionData.Value, label: optionData.Label.LocalizedLabels[0].Label })); return optionData;

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
Lucas001 2,575 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rbn_neu,

what is your exact usecase?

You could also get your records etc with a a FetchXML statement which could be easier.

For using these I would highly recommend the FetchXML Builder from the XRMToolbox

Was this reply helpful? Yes No
Verified answer

Fubar 8,514 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Unless there is a reason that the values need to be dynamic (e.g. you are filtering based on other values that may change), I would retrieve them in Liquid fetchxml as it runs server-side so no having to wait for another api response before working with them.

What you are looking for are held in the stringmap table. Quick search gave this video which shows what you need.

https://www.youtube.com/watch?v=sdGpD4N1Luc

Edit: just adding another link https://www.linkedin.com/pulse/how-get-choices-list-microsoft-power-pages-using-table-ranasinghe-p2brc

1 people found this reply helpful.

Was this reply helpful? Yes No