Hey
I have come across an issue that I seem to not be able to solve.
Inside a sharepoint folder i have an excel file that I need to import into into the model driven app (dataverse)
The issue is regarding choice field. In the excel file I get the string value, however, dataverse seem to only be accepting the choice value that is inside dataverse. This is causing a problem because I dont have the choice value(integer).
Until the parse json it is all fine. After the Parse Json I am left with the string name. In the table there is 10 different types of choice fields. A dropdown can have up to 25 different choices. Switch is therefore not an option as i understand. I then tried (second picture) to create and append the variable however this is only used for one choice field.
So my question is: How can i do this in the most easy way? because now this is not really working the way i want it. :)