Hello everyone,
I have 2 spreadsheets in One Drive for business; spreadsheet 1 I have FULL access, spreadsheet 2 I have READ ONLY access. Spreadsheet 1 has two columns: "Email Addresses" column and a "phone number column". Spreadsheet 2 has only one column: "Email".
The first goal is to compare both spreadsheet's email addresses/email columns and find the differences - if email address in spreadsheet 1 is NOT on spreadsheet 2 then save those values (outputs). This is working just fine.
The second goal is to sent a text to the phone numbers (phone numbers column in spreadsheet 1) for the emails that were captured in the output.
Because of the way I have my flow setup now, when the flow runs, it tries to send the texts to the "outputs" but, obviously it doesn't work since it tries to send the text to the email address instead of the phone numbers....how can I fix this so that the texts go to the phone number instead of the email address? (phone numbers that correspond to the emails that were captured in the outputs).Is this possible?
