How to bind DataVerse Choices field to a Combobox in Model Driven Custom Pages/ Fluent UI combobox in canvas app

Hello everyone and welcome to my blog. In today’s blog we will walk you through the following scenarios.

• Bind DataVerse Choice/ Choices field to a combobox in custom pages
• Bind DataVerse Choice / Choices field to a canvas app Fluent UI combobox.
• Show a DataVerse Choice field in a custom page in Model Driven app.

If you want to know how to bind a regular Combobox canvas app control to the Choices field of DataVerse, you can follow my blog link here.

Let’s get started. My DataVerse table Projects has a Choices field – Capability. It’s values are synced with a global Choice.

Below are the items in the Capability choice.

My requirement is to display these items in a Combobox in Model driven apps custom pages. Controls in custom pages are fluent UI controls. So the same concepts shall apply when you use a Fluent UI combobox in canvas apps.

I add the Project table as a datasource of my canvas app. Below is the formula set in the Items property of the Combobox to display the list of items in the Capability field.

Choices(Projects[@cr129_capability])

As you can observe, I am using the Choices function to display the item list of the DataVerse field. And below is the screenshot of the output.

Well it display something but not what we want. It displays the text but not the value.

How do I get the Text of the choices to display? And this is where it is different from traditional combobox in canvas apps.

Navigate to the properties window of the combobox and then click on the Edit button in Fields section.

Click on Add Field and then add then check the Value option and the click on Add.

And now you should be able to see the labels of the options in your Fluent UI combobox.

Hope you liked this post. If this post has helped, you can buy me a coffee. Links on right pane.

For similar topics on Microsoft.NET and Power Platform, subscribe to my blog using the Subscribe option on right pane.

You will also like the below posts.

Debajit Dutta
Business Solutions MVP