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 Automate
Suggested Answer

Essay Scoring Flow

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I was wondering if this would be possible using Flow:

 

  • There are 3 SharePoint fields available in a list: Essay Title(text field), Reviewers(people picker), Score (number field)
  • A user would upload an attachment(essay) to the list
  • A user would use the people picker to select multiple reviewers
  • **Only the reviewers in the people picker should be able to view the list item**
  • When "attachment" = yes, an email would be sent to the reviewers notifying them of the new essay with a link to the URL of the attachment
  • The same email would provide a link where the reviewer could provide a score (1-10) after reading the essay

 

The issue I'm having is the last bullet. How could I provide an environement in the list to collect the scores of each reviewer? Also, each essay could be reviewed by a different # of people.

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Lp939,

     

    It might be not possible to achieve this. As currently Attachment in SharePoint list cannot be used as dynamic content or there is no action can be used to get attachment in SharePoint list.

     

    I have seen a similar idea at Flow Ideas Forum, please consider to vote and comment the idea at here:
    https://powerusers.microsoft.com/t5/Flow-Ideas/Copy-SharePoint-list-attachments/idi-p/10826

     

     

    Best regards,
    Mabel Mao

  • CU16121026-0 Profile Picture
    2 on at
    Creating an efficient essay scoring flow is crucial for both educators and students to evaluate writing effectively. A good system should consider key elements like structure, content, grammar, and originality. Automated tools or rubrics can streamline the process, providing consistency and faster feedback. For students seeking to improve their essays, services like https://payforessay.net/ offer expert guidance. They assist with crafting high-quality essays that meet scoring criteria, helping you understand how to structure arguments and present ideas clearly. Combining professional help with a well-designed scoring flow ensures better results and fosters learning. Simplify scoring, and enhance writing quality today!
  • Suggested answer
    Zdenka_Cech Profile Picture
    101 on at
    Hi 
    you may add 'Approval with custom response' when the condition is met - the attachment is there or other criteria in your flow. 
    it will send an email/approval item in Teams
     
    it gives you various options. 
    There may be a limitation to show only 5 items as custom response for 1-10 score scale in outlook. 
    But I tested and works fine all 10 custom answers values 1 to 10 are there. 
    looks like following in outlook message:
     
     
     
    similar in teams Approvals
     
    I would recommend adding a column 'ReviewStatus' (SharePoint if it is uploaded to a document library) with some status values (numbers for better filtering) which control how far is in the process of review and use it later in flow in its conditions or update when you collect from all reviewers scores.
    Specially if you use when item is created or modified you can setup Trigger condition to start when the status has specific number only.
    Not sure what do you do with scores, but maybe you want to collect them and do some calculations.
    I would create separate list to collect all answers with the related document library file ID, so you maybe want to do a calculation once all scores are collected and output to a report. 
     
    *Zdenka
  • CU04041149-0 Profile Picture
    2 on at

    Since the number of reviewers varies, consider creating a separate SharePoint list called "Essay Reviews," capturing fields like "Essay Title," "Reviewer Name," and "Score."

    This solution ensures efficient collection and management of reviewer scores, regardless of how many reviewers you have per essay. By the way, if you're looking to experience Dubai's luxury after completing this setup, consider renting a high-performance sports car from sport rent a car dubai.

    After reviewers submit their scores (via Microsoft Forms or a custom Power Apps form), Flow writes the data into this "Essay Reviews" list. This method handles a variable number of reviewers elegantly.

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 632

#2
Haque Profile Picture

Haque 458

#3
Valantis Profile Picture

Valantis 357

Last 30 days Overall leaderboard