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.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

a33ik 3,306 Most Valuable Professional on at

Like (2)

Report
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.

Was this reply helpful? Yes No
NativeNass_ 223 on at

Like (0)

Report

Thank you @a33ik

We'll look into that!

Was this reply helpful? Yes No
Parvez Ghumra 1,579 Moderator on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (0)

Report

@parvezghumra theoretically that's doable but it would create more issues over bringing value.

Was this reply helpful? Yes No