Compare a Sharepoint list column value to another Sharepoint list column to see if they match

(0) Share

Report

Posted on by YapaYapa

125

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?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Fedegallo ,

After you split the emails, you need to check each resulted email. So you have to iterate through all values and filter the list for this values.

1. Apply to each (outputs Split e-mail)

2. SharePoint Get items ( with filter parameter filled with correctEmailColumns eq items(‘Apply_To_Each’)

3. Condition - check for result emptiness - empty(body(‘Get_items’) [‘value’]) eq true

4. If yes send warning email.

Was this reply helpful? Yes No
YapaYapa 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @gabibalaban,
can I have a visual of the steps please?

Was this reply helpful? Yes No
YapaYapa 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Any leads anyone please?

Was this reply helpful? Yes No