Share via

How best to collate feedback from multiple people into one sheet

Anonymous
2021-02-19T13:30:10+00:00

Afternoon all. After some advice in best utilising Microsoft technologies to automate a workflow.

Currently we have a spreadsheet similar to:

Idea Person A Effort Person A Value Person B Effort Person B Value Person C Effort Person D Value
Jet Rollerskates 3 1 2 2 3 3
Fish shaped plate 2 1

This spreadsheet gets populated with new ideas once a month, and shared out to person A, B, C, and D (Note, not all people review everything). They then add/amend their effort and value scores. We then average these out and take the features that are the most valuable and easiest. These get removed from the list (and developed), and the others remain on the list for the next monthly review. This list stretches into 100s of items, and there are 10s of people who review the list.

I have been playing with using Microsoft Forms, Lists, Automate, Power Apps etc to streamline these processes. I'd be curious for thoughts on the best-fit solution using existing Microsoft technologies from others. What are your suggestions?

PS: I've tried using Forms to collate new ideas, using Automate to copy them into a List, and then using a Power App to collate feedback. This works, although I am concerned about volume and the intervention needed when the person-pool changes. Any other suggestions that are more efficient than the current one, and not too much effort to implement would be great!

Microsoft 365 and Office | Subscription, account, billing | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-02-19T16:17:59+00:00

    Hi Daniel,

    First, I appreciate for sharing the detailed information of your scenario, I believe the methods you are using currently are better but since your concern is about when the situation “intervention needed when the person-pool changes”, I believe you need to customize the flow. But to get detailed response and better suggestions, I request you post your concern in the Power Automate Community: Microsoft Power Automate Community - Power Platform Community to get the suggestions from the experts.

    Appreciate your understanding and stay safe! 😊

    Best Regards,

    Chitrahaas

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments