How to map the Dataverse table column which is of Data type as Whole number and format is duration in combo box item property?

(0) Share

Report

Posted on by ANB

7,250 Super User 2026 Season 1

Hi, I have a column in data verse table of data type as whole number and format is duration.

And this is how it looks in model driven app when used in any forms:

Basically it looks like dropdown/combo box and it is OOTB feature in model driven app.

However, I wanted to use this same column in canvas app with Combo box control. How do I use this in items property of combo box?

@Jmanriquerios

@WarrenBelz

Thanks,

ANB

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Jonathan Manrique 2,695 on at

Like (1)

Report
Copy link

Link copied!
Hi @ANB

You must create that set of options within your application, you can do it through a collection based on the way they are in Model Driven Apps.

After doing this, depending on what you need, whether to include it in a form or just to display it, you must call the collection that you have created.

You will also have to do a little logic to be able to save the option set as a numeric field. I show you how to do it

then you must add a DataCArdValue where you will have to do the logic

If( Choice1.Selected.Value = "Option1", 1, If( Choice1.Selected.Value = "Option2", 2, If( Choice1.Selected.Value = "Option3", 3, 0 ) ) )

You can hide the DataCArdValue but it is the field that is being saved in dataverse

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Jmanriquerios , Collection and hard code table was my already go to plan. Thank You!

Thanks,
ANB

Was this reply helpful? Yes No
Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

Hi @ANB

If at the end for dataverse is a numerical column that, through a plugin in Model Driven, is displayed as a drop-down menu. But in the canvas app you have to build it. Maybe you can make a component to have it for other implementations

Was this reply helpful? Yes No