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 / Flow for M.O. Forms Re...
Power Automate
Unanswered

Flow for M.O. Forms Response to pull data from excel based on response and then send approval and if approved send email back to M.O. Form respondent

(0) ShareShare
ReportReport
Posted on by

Hello,

I have a Microsoft Office Form and when a response is submitted, I would like it to pull additional information from an excel sheet (example - Employee ID is submit through form, it uses Employee ID to look in excel sheet to find location of individual listed) then it sends all this information for approval to the approvers and approvers either approve or deny which sends emails to the original person who submit the Form.

I know how to do the Form sends response for approval piece. I can not figure out how to have the email sent for approvals pull additional information from the excel sheet based on the employee ID entered in the M.O. Form response.

Thanks for all the help!

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @WagRoady 

     

    Assume excel file looks like this 

    Nived_Nambiar_0-1683769532603.png

     

    MS Form looks like this

     

    Nived_Nambiar_1-1683769559319.png

     

     

    Entering employee id will help to extract other details from excel file .

     

    Flow should look like this for approval :

     

    Nived_Nambiar_4-1683769746407.png

     

     

    Nived_Nambiar_3-1683769701831.png

     

    This is how you can extract details from excel file based on employee ID entered in MS form and can be sent for approval 🙂

     

    Hope this helps !

     

    Mark it as solution if it resolves your query !

     

     

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 589

#2
Valantis Profile Picture

Valantis 459

#3
11manish Profile Picture

11manish 382

Last 30 days Overall leaderboard