Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Best Option for multi ...
Customer experience | Sales, Customer Insights,...
Suggested answer

Best Option for multi option and workflows

(1) ShareShare
ReportReport
Posted on by Eilidh32 10

Hi all,

I'm looking for some advice to see if there are any options available that I may not have thought of for the below problem....

We have a number of different business units that we would like to know if there's potential cross selling available when adding a new opportunity.

We will add the new opportunity and a field will be available to select one or a number of different business units.

I thought that the Multi-Option field had solved all my problems as it does exactly what I need it to however it doesn't appear within SSRS reports (we've managed to get it to work within power bi) and workflows don't work.

Is there any option available that would suit our above challenge ?  or a way to make the multi-option field work within the SSRS reports or workflows?

Any help or advice would be greatly appreciated and will hopefully end me banging my head against a brick wall!! 

Thank you!!  :)  

  • Community Member Profile Picture
    Community Member on at
    RE: Best Option for multi option and workflows

    Hi Partner,

    Can you click Yes under "Did this answer your question?" to close this thread if my answer is helpful.

     pastedimage1635153380166v1.png

    Thanks. 

  • Inogic Profile Picture
    Inogic 438 on at
    RE: Best Option for multi option and workflows

    Currently we cannot use Multi-Select Option Set fields in SSRS Reports as this is a limitation of the Multi-Select Option Set field type.
    As a workaround, you could copy the Multi-Select Option Set selected values to a text field using a Plugin/JavaScript and then use the text field in your SSRS report or your workflows etc.

    Hope this helps.

    Thanks!

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Best Option for multi option and workflows

    Hi Eilidh32,

    Workflows are not able to use MultiSelect Option Sets as conditions or part of the create/update step. MultiSelect Option Sets can be used as entry criteria to trigger a workflow.
    MultiSelect Options Sets aren’t available for use in SSRS reports.

    They both are limitations of the Multi Option Set field type, you can refer following links for more limitations about it:

    Limitations of Multi Select Option Sets in Dynamics 365 CE – Nishant Rana's Weblog

    Microsoft Dynamics CRM MultiSelect Option Sets: Pros and Cons Armanino (armaninollp.com)

    So you could create a new text field and use flow/js to copy the value of MultiSelect Option field to a text field, then use the text field in your SSRS report.

    Using flow to replace workflow:

    Use Flow To Update A Multi Select Option Set — Endeavour365 for CRM

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.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans