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 / Daily Lead Count and s...
Power Automate
Unanswered

Daily Lead Count and save success and failed lead in excel sheet

(0) ShareShare
ReportReport
Posted on by 48

Hello,

i have created some automated workflow using power automate , but right now i am looking for daily how many success and failed leads generated that leads added in different excel sheet. can anyone help me?

Categories:
I have the same question (0)
  • Sundeep_Malik Profile Picture
    6,484 on at

    Hey @Arnablaha 

     

    You can make three variables for this.

     

    1st variable to count all the leads. [Or at the end of the flow, just add the other two variables]

    2nd variable to count success leads.

    3rd variable to count fail leads.

     

    You can use a condition action, for success and failed leads. After this use increment variable action. At the end of the flow just add 2nd and 3rd variable and that will be answer to your first variable. And then store it in the excel.

     

    Sundeep_Malik_0-1667985032957.png

     

    Sundeep_Malik_1-1667985135299.png

     

    Outside apply to each do this:

    Sundeep_Malik_2-1667985186384.png

     

     

    Expression:

    add(variables('Success'),variables('Fail'))
     
    After this step you can store these values in an excel table.
  • CU05111601-0 Profile Picture
    1,091 Super User 2024 Season 2 on at

    Hi Arna,

     

    Can you specify your problem more? It sounds like you want some statistics based on your flow, is that correct?

  • Arnablaha Profile Picture
    48 on at

    i am create a flow where i revived leads ,
    right now i am trying to create a new excelsheet where daily success and failed lead saved and after day end this excelsheet sent to mail, how to create this event, please suggest

  • Arnab4 Profile Picture
    2 on at

    can you provide me some other steps there i can saved success and failed leads data for a day in excelsheet and those excelsheet only end of the day, right now i am using automate flow

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