Hi,
I have quite a straightforward requirement. I have an entity in dynamics 365 with a multioptions set field. I need to write data to an external datatable using flow, and need to write the lables of the selected options. Unfortunately I get an empty lable here.
Can someone guide me how I can get the selected lables?
Thanks!
Solved! Go to Solution.
Hi @Symira
If you happy with the response could you please mark it as accepted solution.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Symira
When you run List Records action and are you getting the selected option lables with value in response? please share the output if possible?
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Hi,
CDS doesn't support multiselect optionset values yet. You need to get Dynamics connector for this.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Symira
I have a working solution for this. Will update to later this evening.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi DeepakS,
The field_value has a comma seperated array of selected options. The field_label is null
Hi,
In fact I am already using Dynamics connector. In spite of that the field_value provides me a comma seperated array of values of selected fields, the field_lable is null
Dynamics connector returns the multi-select option label as null but the selected values will be retrieved as comma separated values. CDS connector don't return any values or label.
Here I will explain how to retrieve the labels from multi-select option set.
My entity name is called Sports and I have got a multi-select field called Category.
Here I am have a manual trigger and next step is the list records (Dynamics Connector)
Next we need to iterate the values from Sports entity where I have couple of records selected as multi-select under the category field.
Above I have used a compose to get the selected multi-select value from each record. Remember these are comma separated values. So in my next step I have used a split expression to split each selected option select values.
Above expression I used is as follows:
split(outputs('Compose_-_Selected_Multi-Select_Values'),',')
So the split is going to give us multi values as an array. So again we need to use another loop to iterate the values. Remember the below loop is within the loop we have declared above.
Above compose will give us each selected values. This is a numeric value.
To get the label text using the above option set numeric value we need to use the "String Maps" entity using the filter query as entity name (ajb_sport) and attributevalue equal to numeric value of multi-select option set value.
Because it's a list we need another For Each Loop (Again within the earlier for each loop) to iterate the values of the text.
Note: We have overall three loops within each other. Yes too many loops 🙄
These are my test run results:
Hope its all make sense.
If you have any questions related to this please let me know.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogGreetings,
I have been following along with your reply, as I too, am looking for labels not values from a multi-select option set in Dynamics 365.
However, I am getting this error,
Could you please post your List Record Filter?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogGreetings,
Here is my List records - Filter by...
Hi @fklatecki
Thanks. That mapping looks good to me. Make sure that output is not a string value you are mapping.
Check the run history to identify?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogCan you send me a link for a screenshare?
Regards,
Frank
Hi @fklatecki
Check your email?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogGreetings,
Thank you for the elegant solution, to the MultiSelect Option set "view label" issue.
Consider this item solved...
Hi @Symira
Did you looked into this solution? Try this and let me know how it goes. If all good then please mark it as solution accepted as it will help others in community.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi abm
Thanks for your detailed reply. This works absolutely fine. The entity "String Maps" as the missing part in the puzzle for me. The solution works fine. At the same time, I feel this workaround would not be necessary if Microsoft would fix this bug. Are you aware if this bug has been reported to Microsoft.
Thanks to you any ways for helping fix this issue for now and for future 🙂
regards
Hi @Symira
If you happy with the response could you please mark it as accepted solution.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThe first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
69 | |
27 | |
22 | |
16 | |
13 |
User | Count |
---|---|
132 | |
43 | |
42 | |
34 | |
31 |