web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / multiperson Form and f...
Power Automate
Unanswered

multiperson Form and feedback loops

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello everyone,

I'm new to applying power automate to problems, so apologies if I am missing obvious insights.

At my workplace I look after a process of jobs being assessed, with colleagues providing a number of metric scores (provided as percentages) ultimately providing a weighted average. Two colleagues assess the job, but need to be within a certain percentage range (e.g. within 10%), yet submit reports independent of each other. If their metrics are too far apart then scores have to be subsequent re-submitted so they are within that window.

Currently, this requires a lot of intervention from the original assessors and those coordinating behind the scenes. I felt this feedback loop would be ideally suited to a PA flow scenario. I would be interested to know from the community where I might find examples of such a flow. I was thinking along the lines of each assessor completes a Forms trigger before feeding into an Approvals process. If the final weighted averages are >10% the forms are returned for adjustment and notification by e-mail??? That's what I am thinking.

Sorry for being verbose, but looking for a pointer primarily.

Cheers, drdrc

Categories:
I have the same question (0)
  • eric-cheng Profile Picture
    5,171 on at

    Hi @Anonymous ,

     

    Welcome to the community.

     

    MS Forms is a good start.  The issue is that you will rely on manual input to relate the assessment/form response to what is being assessed.  For example, you might be assessing a car with VIN 123456.  Assessor 1 and 2 will need to make sure they type in 123456 correctly for your flow to match both responses up and do the calculation.  If this is OK, I think your idea should be fine.  

     

    Alternatively, you could look at creating a SharePoint list with relevant lookups and customize it with PowerApps.  There is a blog here and here.

     

    I understand there will be a bit more of a learning curve which is why I said the MS Forms approach is a good start.

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @eric-cheng, thanks for your recent thoughts and suggestions. I've had a play and think. I've managed to now:

    • Get items from sharepoint list
    • Create an array with an identifier (egg a person's name) from all rows in the SP list
    • Use the union() function in a compose action to generate a list of unique names

    I would like to access each name to use this as a SP ODATA filter criterion within an apply to all loop. My idea being that I can further probe each sublist in turn to see whether further action is required, as per my original post.

    I can not work out how to access each name in that Compose Action! It feels like it should be simple...but my PA inexperience and working in different languages is making this intractable. 

    Thanks...drdrc 

  • eric-cheng Profile Picture
    5,171 on at

    Hi @Anonymous ,

     

    Could you post a few screenshots as this will help me provide a correct solution.

     

    If I understand it right, you now have an array and you want to access each item in the array (possibly to generate an email string?).  You would loop through the array and use the below expression to reference the current time.  Replace the ColumnName with the column you want to reference.

     

    item()?['ColumnName']

     

    ericcheng_3-1634435978205.png

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard