Hi @SudeepGhatakNZ
where would that expression sit, and does it handle all 8 questions? (I was thinking I would need 8 of these to enter each one against the column names in the Create Item.
To outline the scenario, if it helps:
I have a form with a number of questions, one which is a multi-choice answer which is required (so will have any combination of 1 to 8 answers)
I need to take the choices selected from this question which are string based, convert them to the right format to update a 'Yes/No' column type in SharePoint (true/ false I assume) and update each column in SharePoint when creating the Item that has a true passed through for it.
The flow broadly is as follows:
1. Manually trigger a flow (for easier testing)
2. Get Response details (from form)
3. Initialise several variables used in the switches later. I initialise one for the 'Service' selected for the multi choice question as follows:
4. We then go into formatting the form outputs, and for the 'Service' question, I have a JSON Compose and then a Select to separate the values to items
5. I then tried (and failed) to use a split to separate out all the items in the 'Compose Service Split' with the following expression:
split(body('Select_BA_Service'),',')
I'm not sure if it's right, but it expects a string and but the output from 'Select BA Service' is an array.
6. Further on in the flow, I try and use a switch to change each output value from the 'Compose Service Split' to a Yes/ No answer:
and so on (I have 8 cases, plus a default)
7. I'm then trying to compose as you stated the If statement:
If(equals(variables('varService'),'Yes'), true, false)
8. I then try and use the output from this in the Create Item against each column:
It basically fails right up at the Compose Service Split:
Unable to process template language expressions in action 'Compose_Service_Split' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'.
If I remove the Split, the Switch for changing the question responses to Yes/Nos in pint 6 above fails:
The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@body('Select_BA_Service')' is not valid. It is of type 'Array' but is expected to be a value of type 'String, Integer
It's become a bit of a muddle!
If we can step through the scenario, I think we can sort it 🙂
Thanks
