![\"Bulk](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/03\/1-Bulk-Edit-Multiselect-optionsetchoices-fields.png\")
<\/a><\/p>\nHow we can then achieve this?<\/p>\n
If we search for this over the internet, we will find that we need to create an on-demand Workflow with custom assembly to update the Multiselect optionset field. Custom workflow assembly because again Multiselect optionset fields does not show up in Update record properties form of the Workflow step.
\nFinally, I am able to achieve this using Power Automate Flow. Let us see how you can bulk edit Multiselect optionset fields using Power Automate Flow.<\/p>\n
\u2022 Go to https:\/\/make.powerapps.com<\/a> and create a new \u201cInstant Cloud Flow\u201d<\/p>\n \u2022 As we have to run the Flow on the multiple selected records, select the \u201cWhen a row is selected\u201d from the list of triggers and click on Create.<\/p>\n \u2022 This will create a flow that we can run on selected records from Dynamics 365 CRM or CDS\/Dataverse environment.<\/p>\n \u2022 Select the environment and select the entity where you want to bulk edit the Multiselect optionset field.<\/p>\n \u2022 Add a new step and select the \u201cUpdate a row\u201d action. Using this we will update the current selected record\/row.<\/p>\n \u2022 After this, select the entity and pass the unique identifier of the record.<\/p>\n \u2022 Now, look for Multiselect optionset field from the list of fields. You will see that you can only select one option at a time. Though it is a Multiselect option, we can only select one option.<\/p>\n In the below screenshot, Operation is the Multiselect optionset field with options as \u201cCreate, Update and Read\u201d. We are able to select an only single option.<\/p>\n \u2022 To set multiple options, we need to write the expression. Click on \u201cEnter custom value\u201d, this will open up the expression box. Click on \u201cExpression\u201d and enter the following expression, string(0, 1)<\/p>\n Here 0 and 1 are the values of options of the Multiselect optionset field. In my case, 0 and 1 are the option values of Create and Update option respectively. Each option value is separated by a comma \u2018,\u2019<\/p>\n Syntax of the expression is, string (<value1>, <value2>, <value3>)<\/p>\n \u2022 Save the flow and run it by selecting the multiple records,<\/p>\n This way we can easily edit Multiselect optionset fields by using Power Automate Flow. Introduction I ran into a situation where I need to edit the Multiselect optionset (choices) field in bulk. I thought it could be easily achieved by using the Bulk Edit option but there was a problem. I could not do that because when I select the records and click on Bulk edit, the form does\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1985],"tags":[2210],"class_list":["post-27327","post","type-post","status-publish","format-standard","hentry","category-power-automate","tag-microsoft-power-automate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/27327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=27327"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/27327\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=27327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=27327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=27327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nConclusion<\/h2>\n
\nHope this helps! Thank you!<\/p>\n<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"