function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nandhini S 3Nandhini S 3 

How to get multiselect picklist values?

Hi all,

When I query a multiselct picklist field, it returns only the API names not the values. How do I get the values?
SwethaSwetha (Salesforce Developers) 
HI Nandhini,

When querying a multiselect picklist field in Salesforce, the API names of the selected values are returned by default. To get the actual values of the selected options, you can use the INCLUDES operator in the SOQL query.

Try 
SELECT Id, Name, MultiSelectPicklistField__c
FROM ObjectName__c
WHERE MultiSelectPicklistField__c INCLUDES ('SelectedValue1', 'SelectedValue2')

Related:
https://salesforce.stackexchange.com/questions/301850/soql-query-for-multiselect-picklist
https://www.biswajeetsamal.com/blog/querying-multi-select-picklists-in-soql/
https://help.salesforce.com/s/articleView?id=000386734&type=1

If this information helps, please mark the answer as best. Thank you
 
Arun Kumar 1141Arun Kumar 1141
HI Nandhini,
 
To get the values of Multipicklist Field you can query be like- 
SELECT Id, MultiPicklistField__c
FROM Object__c

If this helps you please mark it as a best answer
Thanks!
 
Nandhini S 3Nandhini S 3
Hi Swetha,

Thanks for your response. I'm using a flow to update a text field in object B with the values of a multiselect picklist field in object A. Is there a way to get the values in flow?
Satya Kireet 1Satya Kireet 1

Hi Nandini,

To get the Label of MultiSelect Field you can query: 

select id,toLabel(Test_MultiSelect__c) from account

 

If this helps you, please mark it as the best answer
Thanks!
Nandhini S 3Nandhini S 3
Hi Satya,

Is there any way to do this in flow?