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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Find Excel cell data i...
Power Automate
Unanswered

Find Excel cell data in an email subject

(0) ShareShare
ReportReport
Posted on by 30

Hello wonderful community members.  I hope someone out there can help me with a flow that is about to kill me!  I've rewritten it several times, tested and only parts of it work, it never has been successful.  The flow is this:  New email arrives in shared mailbox, open an excel spreadsheet, use the numbers located in column 3 to see if any are contained in the email's Subject.  If found, move the email to a new folder.  I have the trigger on new email step working, the grabbing of all the rows in the Excel Table, and the condition that moves the email to specific folders comfortably working, but I cannot get the excel cell numbers to be found in the email subject line (oh and the flow can finish looking for matches after just one match)!  90 fails later, I'm begging for your help.  Thank you so much in advance!
Flow.png

Categories:
I have the same question (0)
  • Verified answer
    v-yetonggu-msft Profile Picture
    on at

    Hi @AppNewbie ,

    Please switch to classic designer.

    vyetonggumsft_2-1711071049990.png

    I did a test for your reference.

    In my scenario:

    I want to move the subject of the newly arrived email containing the number in Column3 from the Inbox folder to the Archive folder.

    My Excel Table:

    vyetonggumsft_4-1711071246767.png

    Archive Folder:

    vyetonggumsft_2-1711072557676.png

    My Flow:

    vyetonggumsft_0-1711070853041.png

    Use contains instead of is equals to in condition:

    vyetonggumsft_3-1711072804126.png

    Best Regards,

    Sunshine Gu

  • AppNewbie Profile Picture
    30 on at

    Oh my gosh, thank you so so very much!  I'm glad to see I was on the right track (still learning every day), and you gave me exactly what I needed in your great instructions!  I appreciate you very much, thank you.  Have a wonderful day!!

  • AppNewbie Profile Picture
    30 on at

    Unfortunately it is failing every time.  I've checked the raw inputs and the number is being found in both the subject and the excel sheet, but it's not seeing it as a match.  The number is 11 digits long, does that matter?  Maybe I should have the data exported as a sharepoint list instead?  Maybe the number isn't being recognized as text?  Should a step be added to list just the numbers in column 3 then use them?  I've run it a dozen times and it fails every time... I tried retyping the number in the Excel spreadsheet, checked permissions on the mailbox, nothing works.

  • AppNewbie Profile Picture
    30 on at

    Ive determined it is definitely the Excel spreadsheet it doesn't like.  I need to figure out a way to access the data not in an Excel spreadsheet.  Thank you again

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard