I have built a form that has answers such as strongly agree, agree, disagree, strongly disagree. I am then using power automate to put the results into an excel in sharepoint. However, I am wanting to score the responses.
Is it worth trying to handle the responses in power automate and convert the 'agree' to a 2 for example and try and add them up, or is there a way in which the results can be put into the excel file, and there are formulae in the excel file that can automatically be 'dragged down' when each result is input and then power automate can get the result from the excel file?
Does that make any sense? If so, it would be great to get your thoughts!


Report
All responses (
Answers (