Get Choice Column Value from Dataverse in Power Automate

I will be showing you how to get choice column values from Dataverse using Power Automate, which includes multi-select and single-select choice columns, local choices, and global choices using the HTTP Request from Microsoft Entra ID (Preauthorized) connector.

Request URLs:
-Single Select Column Template:
/api/data/v9.2/EntityDefinitions(LogicalName='{{Entity}}')/Attributes(LogicalName='{{Column}}')/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName,SchemaName,AttributeTypeName&$expand=OptionSet($select=Options)

-Single Select Column EXAMPLE:
/api/data/v9.2/EntityDefinitions(LogicalName='isa_plants')/Attributes(LogicalName='isa_type')/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName,SchemaName,AttributeTypeName&$expand=OptionSet($select=Options)

-Multi Select Column Template:
/api/data/v9.2/EntityDefinitions(LogicalName='{{Entity}}')/Attributes(LogicalName='{{Column}}')/Microsoft.Dynamics.CRM.MultiSelectPicklistAttributeMetadata?$select=LogicalName,SchemaName,AttributeTypeName&$expand=OptionSet($select=Options)

-Multi Select Column EXAMPLE:
/api/data/v9.2/EntityDefinitions(LogicalName='isa_plants')/Attributes(LogicalName='isa_leafcolor')/Microsoft.Dynamics.CRM.MultiSelectPicklistAttributeMetadata?$select=LogicalName,SchemaName,AttributeTypeName&$expand=OptionSet($select=Options)



Connect with me:
  / isabelliu-powerplatforms