{"id":3210,"date":"2018-08-19T12:03:54","date_gmt":"2018-08-19T12:03:54","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=3210"},"modified":"2018-09-03T10:08:18","modified_gmt":"2018-09-03T10:08:18","slug":"get-option-set-value-based-on-label-in-microsoft-flow","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=3210","title":{"rendered":"Get Option Set value based on label in Microsoft Flow"},"content":{"rendered":"

Introduction<\/strong>
\nIn this article, we will discuss how we can get option set value in Microsoft flow using string map entity.
\nRequirement<\/strong>
\nLet\u2019s say we need to process one import file which will be available in one drive for business and we want to get option set value of relationship type label available in RelationshipType column.
\n\"flow2\"<\/a>
\nSolution<\/strong>
\nIn my earlier article, we discussed how we can use string map entity to get option set label based on it\u2019s value using Web API<\/a>. We can also use string map entity to get option set value based on its label. We can use the following steps
\n1. Navigate to Flow from your office 365 or from Dynamics 365 apps menu and click on Create from blank.<\/strong>
\n2. We will be using One drive for Business trigger- when a file is created, so select one drive for Business and select create file trigger like following
\n\"flow3\"<\/a>
\n3. Click on the File picker and select root folder, where we will be uploading the file.
\n\"flow4\"<\/a>
\n4. Now let\u2019s create a variable where we will store returned value. Click on + New Step and select Add an action<\/strong>.
\n5. Write Variable<\/strong> under the search text field and select Variables<\/strong>. After that select initialize variable action.<\/strong>
\n\"flow5\"<\/a>
\n6. Let\u2019s name this variable as relationshiptype
\n\"flow6\"<\/a>
\n7. Now we need to use Get Rows<\/strong> action from Excel, so Click on + New Step<\/strong> and select Add an action<\/strong>. Type Get Rows under text field and select Get Rows action
\n\"flow7\"<\/a>
\n8. Set Get rows action details like following, here HIMBAP<\/strong> is the name of the table in excel import file.
\n\"flow8\"<\/a>
\n9. Now add Apply to each to process records from excel file
\n\"flow9\"<\/a>
\nand configure it like\u00a0following
\n\"flow10\"<\/a>
\n10. Click on + New Step\u00a0<\/strong>and select Add an action<\/strong>. Type Dynamics 365 and select List records action, we need to configure it like following
\n\"flow12\"<\/a>
\nHere relationship type is name of the column in the excel file.<\/em><\/p>\n

11. Now finally we can add Apply to each step\u00a0for List records to parse result and assign the result to our variable like following
\n\"flow13\"<\/a><\/p>\n

Now our flow is ready for the test, when we will upload our excel file to one drive for business our flow will run and we can see output returned like below
\n\"flow14\"<\/a><\/p>\n

Stay tuned for more Dynamics 365 contents !!<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction In this article, we will discuss how we can get option set value in Microsoft flow using string map entity. Requirement Let\u2019s say we need to process one import file which will be available in one drive for business and we want to get option set value of relationship type label available in RelationshipType column. Solution In my earlier… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":3231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21,402,522,593],"tags":[596,595,597,598,600,601,594,599],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3210"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3210"}],"version-history":[{"count":11,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3210\/revisions"}],"predecessor-version":[{"id":3267,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3210\/revisions\/3267"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/3231"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}