Get Option Set Labels in Power Automate flows
Every Option set Option has two Values associated with it :
- Label Value – which is a free text field.
- Value – Which is an integer value as
In any Power Automate flow by default, we only get the integer value of an Option Set Option.
In this blog let’s see we can get a Label of an Option Set Option.
On my Accounts in CRM, I have an Option set Account Type.
I have used a Get row by ID Action to get the Account Record whose Account Type Label I need to get.
The next step is to check the Raw outputs of this Trigger Action and search for your Option Set field name.
You will see 2 values in the body of the Raw outputs as shown below.
Expression : outputs(‘Get_Account’)?[‘body/[email protected]‘]
Gives the Label: Business Combination.
Expression : outputs(‘Get_Account’)?[‘body/cfs_accounttype’]
Gives the Value: 224520002.
Inputs:
Output :
Hope this helps !
Thank you.