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
Solved! Go to Solution.
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 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?
I seem to be able to access it using;
But it includes the brackets - eg. 
Any suggestions please?
Hi @Mld9 ,
We can use the index directly to get the element value in the array variable.
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021