MS Forms Weighted

%3CLINGO-SUB%20id%3D%22lingo-sub-1858054%22%20slang%3D%22en-US%22%3EMS%20Forms%20Weighted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1858054%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20various%20surveys%20that%20we%20send%20to%20client%20using%20an%20external%20survey%20provider.%20I%20am%20investigating%20the%20ability%20to%20satisfy%20our%20needs%20by%20using%20MS%20Forms.%20One%20requirement%20we%20have%20is%20the%20ability%20to%20have%20a%20weighting%20tied%20to%20our%20questions%20as%20I%20have%20specified%20below.%20We%20would%20like%20to%20capture%20the%20scoring%20value%20in%20the%20Excel%20document%20behind%20the%20Form%20for%20easy%20tabulation.%20Can%20someone%20guide%20me%20as%20the%20whether%20this%20is%20possible%3F%20Thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%3A%20How%20was%20the%20quality%20of%20service%20you%20received%3F%3C%2FP%3E%3CP%3E1.%20Superior%20(worth%20100)%3C%2FP%3E%3CP%3E2.%20Good%20(worth%2080)%3C%2FP%3E%3CP%3E3.%20Average%20(worth%2060)%3C%2FP%3E%3CP%3E4.%20Poor%20(worth%2040)%3C%2FP%3E%3CP%3E5.%20Terrible%20(worth%200)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1858054%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1900490%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Forms%20Weighted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1900490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F362619%22%20target%3D%22_blank%22%3E%40Chris_Mancini%3C%2FA%3E%26nbsp%3BIt's%20not%20possible%20with%20Forms%20on%20its%20own%2C%20but%20you%20could%20have%20a%20simple%20flow%20in%20Power%20Automate%20to%20save%20the%20weighting%20number%20(and%20any%20of%20the%20other%20answers%20in%20your%20form)%20to%20a%20different%20spreadsheet.%20The%20result%20is%20shown%20on%20the%20attached%20video.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20is%20shown%20below%20and%20triggers%20whenever%20a%20new%20form%20response%20is%20submitted.%20The%20first%20action%20is%20to%20get%20the%20response%20details%2C%20then%20we%20initialize%20a%20variable%20to%20hold%20the%20weighting%20score.%20Next%2C%20a%20type%20of%20condition%20called%20a%20Switch%20is%20added%20that%20looks%20at%20what%20the%20answer%20was%20in%20the%20question%20and%20then%20for%20each%20case%20applies%20the%20appropriate%20weighting%20to%20it%20and%20set%20the%20variable%20value.%20Finally%20it%20adds%20a%20row%20into%20a%20table%20in%20Excel%20using%20that%20variable%20value%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20582px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234373i0C73E73C7F2FFF08%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Flow.png%22%20style%3D%22width%3A%20699px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234372iC611272ACDE7CE83%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-Flow.png%22%20alt%3D%222-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223a-Flow.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234370i8ED5C13F706FF26C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223a-Flow.png%22%20alt%3D%223a-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223b-Flow.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234371i4C97778447E50450%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223b-Flow.png%22%20alt%3D%223b-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223c-Flow.png%22%20style%3D%22width%3A%20769px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234374iD20B2DE81414B7EB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223c-Flow.png%22%20alt%3D%223c-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%224-Flow.png%22%20style%3D%22width%3A%20840px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234375i36B881A492424FC1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%224-Flow.png%22%20alt%3D%224-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

We have various surveys that we send to client using an external survey provider. I am investigating the ability to satisfy our needs by using MS Forms. One requirement we have is the ability to have a weighting tied to our questions as I have specified below. We would like to capture the scoring value in the Excel document behind the Form for easy tabulation. Can someone guide me as the whether this is possible? Thanks.

 

Question: How was the quality of service you received?

1. Superior (worth 100)

2. Good (worth 80)

3. Average (worth 60)

4. Poor (worth 40)

5. Terrible (worth 0)

 

2 Replies

Hi Chris (@Chris_Mancini) it's not possible with Forms on its own, but you could have a simple flow in Power Automate to save the weighting number (and any of the other answers in your form) to a different spreadsheet. The result is shown on the attached video.

 

The flow is shown below and triggers whenever a new form response is submitted. The first action is to get the response details, then we initialize a variable to hold the weighting score. Next, a type of condition called a Switch is added that looks at what the answer was in the question and then for each case applies the appropriate weighting to it and set the variable value. Finally it adds a row into a table in Excel using that variable value:

1-Flow.png

 

2-Flow.png

 

3a-Flow.png

 

3b-Flow.png

 

3c-Flow.png

 

4-Flow.png

Come back with any questions about this.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Thanks for your response. That is pretty much what I thought would need to be done. I was thinking a list in SP that contained each question with the appropriate weight. When the response was received, the Flow would check the list, get the weight, and update the response record which would have a hidden question that related to each real answer. Thanks again