Thursday, August 11, 2022

Get OptionSet Text and Value Using Microsoft Flow

Introduction:


In this Blog we will see how to get OptionSet Text and Value using Microsoft Flow from MSCRM


Implementation Steps:

 

1. Navigate to https://flow.microsoft.com

 

2. Click My Flows --> Click New Flows 

 

3. For this Demo we are using Instant Cloud Flows

 

rampprakash_0-1660216471208.png

 

 

4. Enter the Name and Select PowerApps and Click Create

 

5. Now Navigate to CRM and get an Account to Proceed further

rampprakash_0-1660216611381.png

 

From the Above Screenshot select the Account id and Have a look on the Industry Drop Down As well

 

6. Now Navigate to Microsoft Flow and Select Get a Row By id then Select the Entity and paste the Account id Copied from Point 5.

 

rampprakash_1-1660216704885.png

 

7. Now Initialize the Variable to get the Value of Industry

 

rampprakash_2-1660217035093.png

 

8. Now Save the Application Click Test and Run Test

rampprakash_3-1660217176084.png

 

9. Once you Ran the Application, you can see Number as Output, let's see how we can get the text from the Option Set Values

 

10. Expand the Get Rows and you will see ODATA File over there Search for Industry in the Body

 

rampprakash_0-1660218391323.png

 

11. Copy the Formatted Value like below

 

industrycode@OData.Community.Display.V1.FormattedValue
 
12. Now Frame the Query like below
 
outputs('Get_a_row_by_ID')?['body/industrycode@OData.Community.Display.V1.FormattedValue']
 
13. Create another Variable and paste the Expression from #12
 
Now Try Running the App and Check the Variable
 
rampprakash_2-1660218520927.png

 

Now you can see the Text from Option Set Values

 

That's it :slightly_smiling_face:

 

No comments:

Post a Comment

Day 11 - Customizing Option Sets Dropdown Fields with JavaScript

  In this Blog, we will see how to Customizing Option Sets Dropdown Fields with JavaScript label1 = formContext.getAttribute( "bosch_op...