I have a flow who get multiselect values from a powerapps app, parse the values in JSON and create a string with the values to update Dynamics.
When I run the flow, I've got an error because my option set is not a valid integer.
I supposed last week that the issue was the comma or semicolon separator between values so I tested with values directly in the field and it worked !
But when I put a variable instead of the values, I still have an error message.
Does anyone has an idea ?
The issue seems to be because the content set on the field/column is a string of the concatenated multi-select item values which is how Dataverse stores the selections in the table. You'll need to split the string and traverse the individuals values as need be. Here's an example:
Hope this helps!
This is a great article I actually used to do the same thing with updating a Choices (multi-select option set) value in the Common Data Service (Dataverse) - Too many name changes! 😁. The connector is not the Common Data Service (current environment) connector, it is the legacy Dynamics 365 one, but it is basically the same process...
Hope this helps.
Thanks for your responses.
Unfortunatly, I still have the same issue with string/integer format.
@EricRegnier with your solution I managed to split the string but when I update the values in my destination I have backslash in my code (I don't know if it's ok) and the flow consider the values as string.
@dpoggemann when I tried the example you sent me, I have an error in step 4 regarding the fact that I have a string (the value from 'compose' in the example) and an integer (the value from 'compose 4') in my condition and it's impossible for power flow to execute the condition.
I may have missing something but I don't see what.
Do you think I made something wrong ?
Do you have any idea on how I can fix this issue ?
Thank you both,
Hi @alex69570, apologies for my delayed response. You're almost there! For the backlashes, how are you concatenating the different values? You can't directly concat from the compose. What I generally do is:
Hope this clarifies...