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 / Select and email addre...
Power Automate
Answered

Select and email address for an approval from a Sharepoint list based on form response

(0) ShareShare
ReportReport
Posted on by

Hi All, I am building a flow to automate the process approval. I have the concept working but need some assistance with one key part. The process / concept is as follows:

  • User submits a timecard request via a microsoft form and select badge id (as key)vividichtarosa_0-1708859575562.png

     

  • I have sharepoint list for user list (The data contains badge ID and email)vividichtarosa_1-1708859628364.png

     

  • When i select badge id in microsoft form, then automated read email and send approval to email and teams based on badge id. Help?
Categories:
I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @vividichtarosa 

     

    This is a kind of lookup question 

     

    see the below demo flow to get an idea on how to do this 🙂

     

    Assume i have a form like this 

    Nived_Nambiar_0-1708865136314.png

     

    Here user will select the employee id of supervisor and submit it. The supervisor details based on employee id can be found in the below sharepoint list 

    Nived_Nambiar_1-1708865202643.png

     

     

    see the flow 

    Nived_Nambiar_2-1708865239272.png

     

    First use the trigger when the form is submitted and use get response details to capture the responses.

     

    2. Next use Get items to the filter the list based on employee id selected 

    Nived_Nambiar_3-1708865311396.png

     

    use the Odata filter query to filter the list based on EmpID column (the internal name of EmpID column is Title column as it has been prepared by renaming Title column in my case)

     

    Now use the apply to each to iterate through the results of get items and send an approval request to the email captured via get items like below

    Nived_Nambiar_4-1708865431598.png

     

     

    Hope this design helps !

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

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

  • vividichtarosa Profile Picture
    on at

    Thank you @Nived_Nambiar  That solved my problem!! 😀

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 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard