Create a Map of Field Labels and Values of SOQL fields Effortlessly!

Have you ever encountered a requirement where you needed a map in Salesforce with SOQL field labels as keys and their respective values as the map values? In this post, we'll explore a simple approach to fulfill this requirement using the getPopulatedFieldsAsMap() method along with the Schema.GlobalDescribe() method. This approach will be helpful in streamlining field mapping and access the field values using their labels.

Below is the sample code snippet :

// Query the Data
Account accRecord = [SELECT Id, Name, AccountNumber, AccountSource, Description, NumberOfEmployees FROM Account LIMIT 1];

// Create the Map
Map<String, String> accountFieldsMap = new Map<String, String>();

//retrieve a map of field API names and values
Map<String, Object> fieldstovalue = accRecord.getPopulatedFieldsAsMap();

//retrieve the field labels 
Map<String, Schema.SObjectField> fieldsMap = Schema.getGlobalDescribe().get('Account').getDescribe.fields.getMap();


//populating the required map with field labels as keys and their respective values as map values.

for(String fieldApiName : fieldstovalue.keySet()){

    Object fieldValue = fieldstovalue.get(fieldApiName);
    Schema.DescribeFieldResult fieldDescribe = fieldsMap.get(fieldApiName).getDescribe();
    String fieldLabel = fieldDescribe.getLabel();

    accountFieldsMap.put(fieldLabel, String.valueOf(fieldValue));

}

//to print map values 
for(String fieldLabel : accountFieldsMap.keyset()){
    system.debug('field label is '+fieldLabel +' and field value is '+accountFieldsMap.get(fieldLabel));
}

        

By combining the power of the getPopulatedFieldsAsMap() method and the Schema.GlobalDescribe() method, we can easily create a map in Salesforce with SOQL field labels as keys and their respective values as map values. This map can be re-used as per the requirements.

Next time you encounter something similar to this, remember this approach to simplify your code and enhance your field mapping capabilities in Salesforce.

Happy coding!

#SalesforceTips #SalesforceDeveloper #Salesforce #Apex

References :

Apex Reference Guide - SObject Class

Apex Reference Guide - Schema Class