web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Spreadsheet Comparison...
Power Automate
Unanswered

Spreadsheet Comparison then send text

(0) ShareShare
ReportReport
Posted on by 30

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?

texts2.jpg

Categories:
I have the same question (0)
  • v-bacao-msft Profile Picture
    Microsoft Employee on at

     

    Hi @ITlearner20 ,

     

    Do you mean to get the phone number contained in another table based on the email address?

     

    Then Get a row action needs to get the phone number from Table 2.

     

    Best Regards,

  • ITlearner20 Profile Picture
    30 on at

    Hello @v-bacao-msft thanks for your reply. I meant that I want to send a text to the phone numbers associated with the email addresses that are in the "output" data operation. The output contains the email addresses that are on spreadsheet 1 but are NOT on spreadsheet 2, that is what I want in the output therefore that parts works ok.

    I am not sure how I can sent a text to each phone number for those email addresses in the "output". I think the output has email addresses only and not the phone numbers associated with those email addresses, that is why I am not sure how I could send a text to those phone numbers. I appreciate your help.   

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard