Unanswered

Get Avaialble options from an Option Set in Power Pages Portal

(0) Share

Report

Posted on by Conway

120

I am building a page that will display a list of records from a Dataverse table. The tabe includes a 'Status' Choice column.

I would like to display the availilable status with radio buttons, so portal user can click a status to just see the records that match the selected status.

The records will be retrieved using fetchXML/liquid, instead of an Entity List, so I can construct the fetchXML based on the selected status, and output the result into a <table> so that I can format it anyway I like.

However, I don't seem to be able to find a way to extract the available options from the 'Status' column. I'm trying to get the available options from the column or from the referenced Choice, so that even if the the available options are updated in future I won't need to update code.

Some people suggested using fetchXML to query the 'stringmap' table which requires adding table permission for portal users to access. But as it's a system table and Microsoft specifically hides it from the 'Tables' page in make.powerapps.com, I am a bit reluctant to fool around with it.

I have investigated the Portal Web API which doesn't have a method to get Option Sets.

The Dataverse Web API does provide a method to do so, but I can't find a way to call it from the Portal.

Anyone know the proper way to achieve my requirement? If not, then I will have to hard code the option values and labels into a Content Snippet.

Categories:

Customize & extend

I have the same question (0)

All responses (5)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (1)

Report
Hi, a few points here:

do you need to use custom Fetch? you might able to use OOB Lists + Filters

do you need to retrieve the Status? if you are building a custom page using HTML/Liquid, I don't see any issues on hard-coding the status code references in your page, this is not something that will be changing

Was this reply helpful? Yes No
HarrisonSouza 7 on at

Like (0)

Report

Thank you, Oliver. I've used the stringmap table with the WebApi and it worked as expected!

Was this reply helpful? Yes No
jlarach07 4 on at

Like (0)

Report

Hi Harrison. I am trying to do the same. Can you please post an example of how you called the stringmap table?

Was this reply helpful? Yes No
HarrisonSouza 7 on at

Like (0)

Report
Hi @jlarach07, sure:

To enable the stringmap table for the WebAPI, you must follow the same process you would do for any other table (e.g. account).
The following is a code sample to retrieve rows from the stringmap table, filtering for the statecode column from the account table:
async function RetrieveAccountStateCodes() { return new Promise((resolve, reject) => { webapi.safeAjax({ type: "GET", url: "/_api/stringmaps?$select=attributename,attributevalue,objecttypecode,value&$filter=(objecttypecode eq 'account' and attributename eq 'statecode')", contentType: "application/json", headers: { "Prefer": "odata.include-annotations=*" }, success: function (data, textStatus, xhr) { resolve(data) console.log(data); }, error: function (xhr, textStatus, errorThrown) { console.log(xhr); reject(errorThrown); } }); }); }

Was this reply helpful? Yes No
jlarach07 4 on at

Like (0)

Report

Thank you @HarrisonSouza! I was able to fetch them from the stringmap table.

Was this reply helpful? Yes No