You’re offline. This is a read only version of the page.
Announcements
So I am building what should be a fairly simple flow.
Q1 of the form asks responders to choose from 1 of 7 options and, depending on that choice, branching takes them to a particular section of the form to complete Likert questions about that Q1 choice. So after Q1 there are 7 sections with multiple questions in each and I don't know which section a responder will choose to answer. Only one section will be answered. Now, I am actually wanting an average of those questions they are asked - and I can do that by simply putting the Excel formula for average into the Power Automate and it will bring across into just one cell the average of the questions answered. However, I don't know how to make it that only the questions that are answered are averaged. Ideally, it would be an 'or' situation so 'average this set or this set or set this depending on whether they are answered. Hopefully an image will help!
Take this back to basics. If I enter the follwing as a test in Excel
Then I get two different averages.
However my question for you is, are you populating the answers to each question in a cell like the above then performing the average formular in its cell. I am not an expert on Excel and Flow. I am thinking does Flow need to write each formular as part of the run in the cell. So would the cell containng the average just need the formular.
I have not perfromed a test but if you used a SharePoint list and calculated the average in a calcualtion column would that not get what you need.
Regards,
Andrew
I am not sure if the above helps in anyway but
Share
Report
All responses (
Answers (
1,962
