Answered

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

(0) Share

Report

Posted on by vividichtarosa

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)
I have sharepoint list for user list (The data contains badge ID and email)
When i select badge id in microsoft form, then automated read email and send approval to email and teams based on badge id. Help?

All responses (2)

Answers (1)

vividichtarosa on at

Like (0)

Report

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

Thank you @Nived_Nambiar That solved my problem!! 😀
Verified answer

Nived_Nambiar 17,608 Super User 2025 Season 1 on at

Like (1)

Report

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

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

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

see the flow

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

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

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! 🙌