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 / Look For Email with at...
Power Automate
Answered

Look For Email with attachment and Send a second request when I don't receive an email from the customer

(0) ShareShare
ReportReport
Posted on by Super User 2024 Season 1

Hello,

I have a script when I receive an email that I would like to break in 3 categories:

1. If the customer send an email with the attachment, then the script take the attachment save it in the folder and then remove it from the inbox.  (this part is already done in the script)

2. If the customer did send an email with NO ATTACHMENT, then the script send another request to the customer. (this part is already done in the script).

*** But I really need to implemented the step below.

3. IF I DID NOT RECEIVE AN EMAIL AT ALL FROM THE CUSTOMER, then I need the script to send another request to the customer same as step 2 above. 

Below is how the script look like.  Step 1 and 2 are working fine, but I need step 3 to implemented in the script as well.

Please show your answer in PAD so I can see the step.

Thank you everyone!

TTC_0-1685541008926.png

 

 

I have the same question (0)
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    So in order for step 3 to work, the bot needs to have a list of emails that you are expecting.

     

    For example, if I was building this for bids that I sent out to potential customers, then I would have a list of all open bids in Excel.  As part of steps 1 and 2, I would update the status next to each bid, with a status date.  Then, as part of my process for step 3, it would have some logic that says (if it's been 3 days since the last status update, and the status update is not "signed and returned", then resend a follow-up email).

     

    Good luck!

  • TTC Profile Picture
    Super User 2024 Season 1 on at

    I am not quite follow your answer.  Is there a way you can show your answer in PAD so I can see the step?

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @TTC 

     

    What @MichaelAnnis is trying to say is

     

    Keep a excel file having list of customer to look details into with customer details + status column

    Loop through each row and checks emails arrives with attachement/without attachment or no emails

    Based on that status is updated accordingly bot, based on value you can decide, to send email to customer who haven't send any email.

     

     

     

  • TTC Profile Picture
    Super User 2024 Season 1 on at

    Is there a way your guys can show me the answer in PAD so I can see the step?

    I don't know where to begin beside I don't want to do anything crazy so I don't break any code on the 1 and 2 step of the email that already in the script.

     

    TTC_0-1685651867505.png

     

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @TTC 

     

    One question here

     

    You are expecting one email from each customer right ?

     

     

  • TTC Profile Picture
    Super User 2024 Season 1 on at

    yes, one email per customer and sometimes multiple attachments on one email.

  • TTC Profile Picture
    Super User 2024 Season 1 on at

    Hi Nived,

    Any updates on this?  Please let me know.

    Thanks!

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @TTC 

     

    It is possible to try this 

     

    See below logic 

     

     

    First create / store a excel which would be having details of customers and their email id whose email needs to check.

     

    Now loop through each of it to retrieve emails corresponding to the customer

     

    Now use if and else if actions accordingly

     

    If mail arrives and having attachments,

    Save the attachment and delete mail 

     

    Else if mail arrives but no attachments are there with mail,

    Send an email to customer requesting for attachments

     

    Else  the customer sends no emails , then send an email 

     

     

    This is the complete logic you should give a try.

     

     

    Hope it helps !

     

  • TTC Profile Picture
    Super User 2024 Season 1 on at

    Hi Nived,

    Is there a way you can show your step through PAD?

    Thanks again!

  • Verified answer
    Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @TTC 

     

    Extermely sorry for delay response

     

    see below

     

    I have created an excel file which has one column Email which contains emails of customers to be looked into as values/rows

     

    step 1 : to read excel file and store in datatable form and connect to exchange server for mails retrieval.

    Nived_Nambiar_0-1686485336359.png

     

    step2: loop through each email and check the required conditions 

     

    Nived_Nambiar_1-1686485390900.png

     

     

    Retreival message action details

    Nived_Nambiar_2-1686485475391.png

     

     

    Hope it helps !

    Mark it as solution if it resolves your query !

     

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 538

Last 30 days Overall leaderboard