Showing external API values in a choice field

(0) Share

Report

Posted on by NativeNass_

223

Hi everybody

We were wondering if it's possible to populate a Dataverse choice column within a form with external values from an API.

Let's just say we would be using the following API: 'JSONPlaceholder - Guide (typicode.com)' and we would like to use JavaScript on the onLoad of the form to populate the choice field within the form with the title values from the API, is this possible?

Thank you in advance.

All responses (4)

Answers (1)

a33ik 3,304 Most Valuable Professional on at

Like (0)

Report

Re: Showing external API values in a choice field

@parvezghumra theoretically that's doable but it would create more issues over bringing value.
Parvez Ghumra 1,579 Super User 2025 Season 1 on at

Like (0)

Report

Re: Showing external API values in a choice field

@a33ik I'm wondering whether another option might be to implement the API based values are a Virtual Table, and to have lookup to target the Virtual Table on the main form, which can then rendered as a drop-down if required using a PCF control?
NativeNass_ 223 on at

Like (0)

Report

Re: Showing external API values in a choice field

Thank you @a33ik

We'll look into that!
Verified answer

a33ik 3,304 Most Valuable Professional on at

Like (2)

Report
Re: Showing external API values in a choice field

Hello,

That won't work, unfortunately with OOB choice fields. Value selected from the list has to be present in the optionset field declaration.

The only thing I can think of is:

Usage of Whole Number/String field (depending on the value you would want to save in Dataverse).

Development of PCF Control with the corresponding field type, querying the values from external source and populating the list of dropdown with the values from external source.