Get Lookup / Power Automate text value instead of guid / integer values using Power Automate

Problem Statement

In Power Automate flows, I was getting GUID for lookup and integer for optionset fields instead of text values for both fields. 

Example

For a contact records below from CRM, I've Account Name as lookup field and Preferred Method of Contact an optionset field.

Solution

To get face values for lookup as well as for optionset, you need to use below expressions

body('SourceDataSet')?['<FieldName>@OData.Community.Display.V1.FormattedValue']

SourceDataSet - the dataset from where you are trying to get face values for optionset and lookup

Field Name - logical field name; 

In our case, source data set is "GetContact" while below are fields

Preferred Method of Contact - preferredcontactmethodcode
Account Name (lookup field) - _parentcustomerid_value

So as par above expression, let complete our expression and put in Power Automate Flows Compose component.

For Optionset, 

body('GetContact')?['preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue']

For lookup,
body('GetContact')?['_parentcustomerid_value@OData.Community.Display.V1.FormattedValue']

Now in Power Automate flow, the expression will be added for optionset and lookup.

This time when I ran the flow test I got face values instead of GUID or integer.

Preferred Method of Contact

Account Name


~~Enjoy~~

Comments

Post a Comment

Popular posts from this blog

How to hide '+' on a subgrid in dynamics CRM?

I’ve to hide ‘+’ button of Order subgrid on Account form, because we are not allowing accounts to directly create Orders. Pre-requisite: Install latest version RibbonWorkBench tool from here  Create a Solutions, OrderRibbonSolution Add existing Entity, Order Publish the customization Launch RibbonWorkBench (RWB), Open the solution OrderRibbonSolution in RWB     4.    Create a new Enable rule and set following properties            a.    Default : False            b.    InvertRule : True            c.    EntityName : account            d.    Context : Form            e.    AppliesTo : PrimaryEntity     5.    Attach newly created Enable rule with the customized commands of all three   buttons.     6.    Hit Publish Solution  Verify by going through the Accounts and Contacts forms. Keep Learning!
Read more

Get Rid off Pending Email Warning - Microsoft Dynamics CRM

Image
Problem This is really weird when you login into MSD CRM and you came across with following screen. Reason This happen when you are sending email using workflow and the email stuck with status Pending Send Resolutions Following are three resolutions to this issue: Go to Settings > Email Configurations > Mail Boxes  and open Mail box ( that don't have approved email address and didn't test run ), then from Ribbon,   Approve Email Address and after that click on Test Run , You will see prompt coming from CRM, check the box click Ok . Create an on-demand workflow, to change the status of Pending Send email messages to some other status, say Canceled. And run this workflow from advanced find against those emails that are set to Pending Send Go to Advanced Find , Look For Email Message and Query for Status Reason  equals Pending Send, click Results and then delete all message with Pending Send Status After following any aforementioned step you'
Read more

How to Rename Status field options of an Entity in Dynamics CRM

Image
Problem Statement Rename State Code options of a custom entity (say Payments); from Active/Inactive to In Progress/Completed. Active Status Payment In Active Status Payment Step by Step Guide Add Payments (custom entity) in solution and from sub-components select only Status (statecode) Export Translation Export Translation Extract “CrmTranslations_PaymentsSolution_1_0_0_0.zip” file Open “CrmTranslations.xml” in Excel In “Localized Labels” sheet, modify the Display name of below cells; Active to In Progress and Inactive to Completed Active/Inactive Display name In Progress/Completed Display Name Save File, update “CrmTranslations_PaymentsSolution_1_0_0_0.zip” file Go back to solution and Click Translation, Select “Import Translation” Import Translation Select Updated “CrmTranslations_PaymentsSolution_1_0_0_0.zip” file and click Import Choose File; click Import After translation imported successfully, Active Records are shown as In P
Read more