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 / Sending different mail...
Power Automate
Unanswered

Sending different mails based on Forms submission count

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

I would like to send two different mails after a certain number of submissions have crossed in my Microsoft Form. The below flow doesn't seem to work. The response ID doesn't match with the number of submissions made.

 

Capture.JPG

 

Capture2.JPG

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    hi @Anonymous  its because the ID is not equals to the # submissions. I recoment you to create share point list then you can add some data to fill a new item, so when you fill a new item sharepoint creates for you an ID per submission you can use it to do your comparation see

    item.PNG

  • Patrick Hess Profile Picture
    Microsoft Employee on at

    avi_suresh,

     

    Just to clarify, responseId isn't really a counter; it's a static piece of metadata tied directly to the individual response. The number does increment up but again, it's not really a counter. I'm not sure if that's a hindrance to your end goal or not.

     

    I did a quick test like so...

     

    PatrickMSFT_2-1597961152675.png

     

    And that expanded Value...

     

    {"webhookId":"98db531b-e63f-4f7f-ad77-fb7b2e38af98","eventType":"ResponseAdded","resourceData":{"formId":"<formId>","responseId":4},"eventTime":"2020-08-20T21:35:31.4458128Z"}

     

    The reason you see that responseId is "4" is because it was my fourth submission of the Form. What you're also seeing is the full Body of the request, so that's all the metadata we have to use; no sign of anything that would be a proper counter.

     

    If your Form is more like a quick survey (meant to be short-lived), responseId may work out just fine. If your Form is supposed to be in place long-term, though responseId may not be as effective.

     

    To your actual logic, I don't think you need Get Response Details or Compose at all. Get Response Details can glean some additional data from fields in your Form but you don't need it for responseId and it still won't give you a counter. If anything, you're more likely to confuse your Flow's logic including it. Same thing with Compose, you don't have to set up any variables here; responseId is already solid.

     

    I set up a Flow like so and it's working fine for me...

     

    PatrickMSFT_1-1597961026106.png

     

    I hope this helps!

     

    Sincerely,
    Patrick

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
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard