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

Sending different mails based on Forms submission count

(1) ShareShare
ReportReport
Posted on by

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,951 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
    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

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 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard