You’re offline. This is a read only version of the page.
69
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!
Hi @Simmo86
You could initialise variables in Power Automate and workout the score within Power Automate. Add an IF condition to determine what the answers are and add or decrement depends on your logic to the defined variable.
Thanks
Share
Report
All responses (
Answers (
