Hello,
can anyone helping me with the following issue?
I have create a Power App form in which user needs to plug in other users' email addresses (multi-line text box as screenshot below)
I would like to compare each of the email addresses with an internal Roster (in another sharepoint list equal to 1600 lines) and if one of the email addresses is wrong, send an email to correct it to the user. Unfortunately I cannot use a people's picker instead of the multi-line textbox for several reason.
What I built so far is not working probably because the email is sent even if the email address inserted in the textbox is correct:
1. I have splitted the emails so that I have single ones:
2. I compare the splitted email with the column of the other Sharepoint list that contains the correct emails:
Any leads?

Report
All responses (
Answers (