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

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,129 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard