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,
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
31 | |
30 | |
24 | |
24 | |
21 |
User | Count |
---|---|
64 | |
57 | |
43 | |
37 | |
29 |