property-set element

Defines an inner configuration within a dataset manifest node to allow you to explicitly configure a column of your dataset against a column of a given type from the table against which the dataset is configured.

Available for

Model-driven and canvas apps

Properties

Name Description Type Required Available for
name Name of the column. string Yes Model-driven and canvas apps
display-name-key Used in customization screens as localized strings that describe the name of the property. string Yes Model-driven and canvas apps
description-key Used in customization screens as localized strings that describe the description of the property. string Optional Model-driven apps
of-type Defines the data type of the property See Remarks Optional Model-driven apps
required Indicates whether the property is required or not. boolean Optional Model-driven apps
of-type-group Name of the type-group as defined in manifest. string Optional Model-driven apps
usage The usage property identifies if the property is meant to represent a table column that the component can change (bound) or read-only values (input). bound or input Yes Model-driven apps

Parent Elements

Element Description
dataset The dataset node in the component manifest represents a specific, configurable representation of a set of table records.

Child Elements

Element Description Occurrences
types 0 or more

Remarks

The of-type attribute value must be one of the following:

Value Description Available for
Currency Monetary values between -922,337,203,685,477 and 922,337,203,685,477 can be in this column. Model-driven and canvas apps
DateAndTime.DateAndTime Displays date and time. Model-driven and canvas apps
DateAndTime.DateOnly Displays date only. Model-driven and canvas apps
Decimal Up to 10 decimal points of precision can be used for values between -100,000,000,000 and -100,000,000,000 can be in this column. Model-driven and canvas apps
Enum Enumerated data type. Model-driven and canvas apps
FP Up to five decimal points of precision can be used for values between -100,000,000,000 and -100,000,000,000 can be in this column. Model-driven and canvas apps
Lookup.Simple Allows for a single reference to a specific table. All custom lookups are this type. Model-driven apps
Multiple This column can contain up to 1,048,576 text characters. Model-driven and canvas apps
MultiSelectOptionSet You can customize forms (main, quick create, and quick view) and email templates by adding choices columns. When you add choices column, you can specify multiple values that are available for users to select. When users fill out the form they can select one, multiple, or all the values displayed in a drop-down list. Model-driven and canvas apps
Object Object data type. Can only be used with output properties. Model-driven and canvas apps
OptionSet This column provides a set of options. Each option has a number value and label. When added to a form, this column displays a control for users to select only one option. Model-driven and canvas apps
SingleLine.Email This stores the string time in the format valid for Emails. Out-of-the-box Unified Interface controls automatically make them clickable links. Model-driven and canvas apps
SingleLine.Phone This stores the string time in the format valid for Phone. Out-of-the-box Unified Interface controls automatically make them clickable links. Model-driven and canvas apps
SingleLine.Text This option simply displays text. Model-driven and canvas apps
SingleLine.TextArea This format option can be used to display multiple lines of text. But with a limit of 4000 characters, the Multiple Lines of Text column is a better choice if large amounts of text are expected. Model-driven and canvas apps
SingleLine.Ticker This stores the string time in the format valid for Ticker. Out-of-the-box Unified Interface controls automatically make them clickable links. Model-driven and canvas apps
SingleLine.URL The text expected to provide a hyperlink to open the page specified. Out-of-the-box Unified Interface controls automatically prepend "https://" to input values that doesn't begin with a valid protocol. Only HTTP, HTTPS, FTP, FTPS, OneNote and TEL protocols are expected in this column. Model-driven and canvas apps
TwoOptions This column provides two options. Each option has a number value of 0 or 1 corresponding to a false or true value. Each option also has a label so that true or false values can be represented as "Yes" and "No", "Hot" and "Cold", "On" and "Off" or any pair of labels you want to display. Model-driven and canvas apps
Whole.None This option simply displays a number. Model-driven and canvas apps

Warning

If the manifest.xml file contains at least one dataset, then properties of type Lookup.Simple should be also wrapped into the data-set element.

Value elements that aren't supported

Following of-type property values aren't supported currently:

Value Description
Lookup.Customer Allows for a single reference to either an account or a contact record. These lookups are available for the Opportunity, Case, Quote, Order, and Invoice tables. These tables also have separate Account and Contact lookups that you can use if your customers are always one type. Or you can include both instead of using the Customer lookup.
Lookup.Owner Allows for a single reference to either a team or a user record. All team or user-owned tables have one of these.
Lookup.PartyList Allows for multiple references to multiple tables. These lookups are found on the Email table To and Cc columns. They're also used in the Phone and Appointment tables.
Lookup.Regarding Allows for a single reference to multiple tables. These lookups are found in the regarding column used in activities.
Status Reason A system column that has options that provide more detail about the Status column. Each option is associated with one of the available Status options. You can add and edit the options.
Status A system column that has options that generally correspond to active and inactive status. Some system columns have more options, but all custom columns have only Active and Inactive status options.
Whole.Duration This format option can be used to display a list of duration options. But the data stored in the database is always a number of minutes. The column looks like a drop-down list and provides suggested options like 1 minute, 15 minutes, 30 minutes all the way up to three days. People can choose these options. However, people can also just type in a number of minutes and it resolves to that period of time.
Whole.Language This option displays a list of the languages provisioned for your organization. The values are displayed as a drop-down list of language names, but the data is stored as a number using LCID codes. Language codes are four-digit or five-digit locale IDs. Valid locale ID values can be found at Locale ID (LCID) Chart).
Whole.TimeZone This option displays a select list of time zones such as (GMT-12:00) International Date Line West and (GMT-08:00) Pacific Time (US & Canada). Each of these zones is stored as a number. For example, for the time zone (GMT-08:00) Pacific Time (US & Canada), the TimeZoneCode is 4.

Note

At this time File columns are not supported. More information: File columns

Power Apps component framework manifest schema reference
Power Apps component framework API reference
Power Apps component framework overview