You’re offline. This is a read only version of the page.
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!
Hi @WagRoady
Assume excel file looks like this
MS Form looks like this
Entering employee id will help to extract other details from excel file .
Flow should look like this for approval :
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 !
Share
Report
All responses (
Answers (
18,138
