Power Platform Community Forum Thread Details

Hi All,

I have MS form having field EmpID, RequestType, and Item list and now when user clicks on Submit button it should check first that entered email id in form is exist in masterdata set placed in somewhere in excelTable with column EmpID listed. and if it matches than send email to manager1 to approve and if this is approve than it should send email to Manager2 and IF in first step Email ID does not exist in dataset it should send an email or notify on form.

Now I am able to store form value in variable and matching with data set thru for each loop however I am facing main issue when EmpID does not exist in dataset than in false condition it is sending multiple emails actually it sending email based on values listed in dataset if there are 4 records to check than it will send email 4 saying not exist, not exist.....