Notifications
Announcements
No record found.
How can we add a Multioptionset field as a column into a report? I don't see the Multioptionset field for a custom entity being displayed when going through the report wizard
Hello Eunice,
Please refer this article for further detail.
community.dynamics.com/.../not-able-to-add-multi-select-option-set-field-in-ssrs-report
Thank you,
Amit Katariya
Hi Eunice,
There are some limitations on Multioptionset field, you cannot add it In CRM report wizard.
As a workaround, you could copy the MultiSelect Option Set values to a text field using a flow/JavaScript and then use the text field in your report.
js:
( ) Set Multiselect option field value in single text line of text in ms crm using js - Dynamics 365 Sales Forum Community Forum
function setOptionsToSomeField(executionContext) { const formContext = executionContext.getFormContext(); //get the selected options (text) var selectedTexts = formContext.getAttribute("gb_multiselect").getText(); //convert selected options to comma seperated string var stringValue = selectedTexts.join(); // Set this value to a single line text formContext.getAttribute("new_sometext").setValue(stringValue); }
power automate:
( ) Multiselect picklist - copy to text? - SOLUTION WORKS!!! - Dynamics 365 General Forum Community Forum
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 70 Super User 2025 Season 2
Gerardo RenterÃa Ga... 33 Most Valuable Professional
Daniyal Khaleel 32 Most Valuable Professional