cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smehro
Helper I
Helper I

Comparing multiple choice answers and assigning them in excel as n largest

Hi,

 

I am trying to achieve 2 highest, 2 high, 2 medium, 2 low and 2 lowest numbers from a row in excel online. The row is the responses from the users by selecting an option from multiple choice answers. For example:

 

Item 1Item 2Item 3Item 4Item 5Item 6Item 7Item 8Item 9Item 10
6544425132

 

In above table, highest number would be 6 (Item 1) followed by 5 (Item 2 & 7). In this situation, I need 2 highest numbers but currently I just have 1 and need to decide which would be 2nd from Item 2 or 7. For this, I ask the user, would you prefer Item 2 or Item 7. Suppose, you says 'Item 7'. With this, I get my 2 highest values as Item 1 & Item 7. [As a consequence when user says 'Item 7', i can either increase value of item 7 with 0.5 so that it becomes 5.5 and clearly 2nd highest.] Similarly, there would be comparison for 2nd high number between Item 3,4 and 5.

 

Now, Is it possible to do this in PVA actions by marking conditions? OR Is there a way to do this on excel in real time as responses are received?

(PS: I tried doing this in PVA conditions using bubble sort logic but it seems brute force and there would be so many conditions.) 

Screenshot 2020-09-23 143702.png

@renatoromao @ChristianAbata @kaznakaxx 

1 ACCEPTED SOLUTION

Accepted Solutions
renatoromao
Super User
Super User

Hi @smehro ,

 

You can do it using the Power Automate, creating the workflow to get all items and current values, and showing to the user using a Markdown detail: https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support

 

But unfortunately, when you will show the options to the user like "Item 2 or Item 7" to select one option of the 2nd, you cannot use the options because today the PVA not allow external values from options question.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

View solution in original post

1 REPLY 1
renatoromao
Super User
Super User

Hi @smehro ,

 

You can do it using the Power Automate, creating the workflow to get all items and current values, and showing to the user using a Markdown detail: https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support

 

But unfortunately, when you will show the options to the user like "Item 2 or Item 7" to select one option of the 2nd, you cannot use the options because today the PVA not allow external values from options question.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Helpful resources

Announcements
Power Virtual Agents News & Announcements

Power Virtual Agents News & Announcements

Keep up to date with current events and community announcements in the Power Virtual Agents community.

Power Virtual Agents Community Blog

Power Virtual Agents Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,640)