SetPicklistValues

Description

Sets the available picklist values. 

Primarily used to filter picklist when they are dependent on another field.

The first parameter is the optionset field name, the second is a boolean which if true will include an empty option set value.

For records with no saved optionset value the first item in the list will be the default if the empty parameter does not exist.

Then you can pass in a list of optionset values, only these will display in the picklist.

Signature

SetPicklistValues(
  'field',
  'emptyvalue',
  'optionsetvalue',
  'optionsetvalue'
)

Example

SetPicklistValues(
  'address1_shippingmethodcode',
  'true',
  1,
  2,
  3
)

Portal

The SetPicklistValues is supported on Power Apps Portals using the same signature:

SetPicklistValues(
  'field',
  'emptyvalue',  
  'optionsetvalue',
  'optionsetvalue'
)

 

Microsoft APIs

This North52 function relates to the following Microsoft APIs:

• getOptions
• getcontrol
• getattribute
• clearoptions
• removeoption
• setvalue