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.650 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.650 students) : English | Português

View solution in original post

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,574)