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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Record appoval process
Power Automate
Answered

Record appoval process

(0) ShareShare
ReportReport
Posted on by 83

Hello All..
I have a SharePoint list.  List contains a email address and VPDecision field (among other fields).  Both fields are text fields.
When a record is created, the VPdecision field is blank. The email field is populated via the PowerApps that creates the record.
What am I trying to accomplish?
Every morning I need to have a flow run that sends an email (to the email address in the email address field) where the person can  approve/deny/delay the request (some type of voting button?), only for records where the VPDecision is blank.  I then want that at decision written back to the record in the SharePoint list.
Help Please.

Thanks


 

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at

    Hi @12strikes 

     

    few doubts -

     

    1. what should be done when delay by request button is clicked- should delay the request by this number of days - should that days count provided as input so that user enters it again ?

    2. Where the approval results needs to be written - in which column ?

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • 12strikes Profile Picture
    83 on at

    Hi @Nived_Nambiar 
    Thanks for responding.
    Any record marked DELAY is taken to a board for them to make the decision, the person in the email field will not be making the decision any longer.
    The Approval Results (approved/denied/delay) should be written to the  VPDecision field.  FYI, that is text field not a choice field.
    Thanks

     

  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at

    Hi @12strikes 

     

    Not sure whether we need to do any actions in flow based on the approval actions- i am assuming you just need to update the approval action results to the list 

     

    see below for flow creation.

     

    1. Create a recurrance flow so that it runs every morning at specific time

    2. Use get items using odata filter query as to filter by VPDecision eq null as shown below to filter only the columns whose column VPDecision equals to null.

    Nived_Nambiar_0-1719680618187.png

     

    3. Use apply to each to loop through each item in get items action's output.

     3.1- Create this type of approval action which can make user to select either Approve, Reject, delay option 

    Nived_Nambiar_1-1719680725922.png

     

    3.2- update the approval action's outcome to same list item using update item action

    Nived_Nambiar_2-1719680772616.png

     

    Nived_Nambiar_3-1719680794142.png

     

    Since the approval action is waiting until user act on this- flow will stuck per loop iteration, to avoid that and make iterations run concurretly- use following settings in apply to each to enable concurrency as shown below

    Nived_Nambiar_4-1719680912729.png

     

    If you expect that there are more than 50 request can come - then make a child flow around this approval and invoke it here and use concurrency to make it run 50 times along with 50 times in child flow which can make overall of 2000+ request can be handled at same time- for the logic refer below

    https://mistershaik.in/bulk-approvals-using-parent-child-flows/

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • 12strikes Profile Picture
    83 on at

    Hi @Nived_Nambiar 
    That's great!  and I like that it does a team notification also.

    The email is sent from Power Automate. Is there anyway to use a Send From address?  I'm worried that people will ignore the email if it looks like junk email from MS.

  • Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at

    Hi @12strikes 

     

    The mails are send from Power Automate side which we can't control- but there is another way- sending custom mails from specific sender itself - same for teams message as well- like below

    Nived_Nambiar_0-1719767937134.png

     

    We have to change the structure a little.

     

    So use create an approval which creates an approval but set these options like below (which are highlighted)

    Nived_Nambiar_1-1719768027019.png

     

    Now use parallel branch- in one parallel branch- send teams message and send email as well like below 

    Nived_Nambiar_2-1719768100762.png

     

    Nived_Nambiar_3-1719768128420.png

     

    in another branch- do like below where it waits for approval actions to be completed and then update item accordingly

    Nived_Nambiar_4-1719768205677.png

     

    Nived_Nambiar_5-1719768234089.png

     

     

    Hope it helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • 12strikes Profile Picture
    83 on at

    @Nived_Nambiar 
    Thank you very much for the additional steps.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard