Please see this image for screenshots of the flow
I have a Microsoft Form with statements which have Strongly Agree / Agree ... etc
I have around 60 questions. Each question needs to have a score. Eg. Strongly Agreee = 5
I initiated ~60 variables to hold the "score" of each question.
Using a condition loop to see if the response == Strongly Agree set the score to 5
The output is then added to a row in Excel.
When running the flow it's taking ~8 minutes.
How could I improve the performance of this please? Can it be done with an array?
Many thanks for your support
M
Solved! Go to Solution.
I can access the value without brackets by using;
variables('answerArray')[0]
Increasing the value from zero as required
Proud to be a Flownaut!
Thanks Josh - but did you see the first screenshot I posted?
I attempted to build an array of the questions & therefore an array of the answers but it's not quite working as I expected.
When running a test it's building the question array as "Strongly AgreeAgree" ? Would expect the "current item" to just be "Strongly Agree" for the first question.
I have updated it & the loop now works as expected
I now have an "answerArray" with the correct scores.
But how can I access the values of the array to insert a row into an Excel?
Thanks
I seem to be able to access it using;
take(variables('answerArray'),1)
But it includes the brackets - eg. [5]
Any suggestions please?
I can access the value without brackets by using;
variables('answerArray')[0]
Increasing the value from zero as required
Hi @Mld9 ,
We can use the index directly to get the element value in the array variable.
Best Regards,
User | Count |
---|---|
91 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
49 | |
47 | |
27 | |
27 |