Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Simple calculation with Flow - Total & Average of a training lists

(0) ShareShare
ReportReport
Posted on by 6

Hi Everyone,

 

I am trying to build my first 'Flow'. As always, when you do something for the first time. It is difficult need some guidance.

 

What I am trying to do?

 

I am trying to calculate the '% of Completion' & 'Avg % of Completion' of the 'Security & Compliance' trainings.

Like below:

 

CMG_1-1616573999352.png

 

 

I have  a list with all the fields like

(a) Training Title

(c) Completed

(d) In Progress

(e) Not Started

 

I want to calculate the following Fields/Values:

(f) Total Assigned

(f) % of Completion

(g) Average % of Completion

 

Can someone please help here?

 

Regards,

Chandra

 

 

  • HeidiN Profile Picture
    HeidiN 34 on at
    Re: Simple calculation with Flow - Total & Average of a training lists

    Hello Chandra!

     

    Yes, you're right - that last column would require something like a custom plug-in or custom code. Where are you implementing this? I have a heavy Dynamics 365 background, so my instinct is always towards solutions there - so I don't want to direct you to the wrong place! I like to take the path of lease resistance when implementing things like this. While Flow is possible, I do think there are better ways. I think you can leverage calculated fields for most of these items you need, and for the % of, perhaps a plug-in or custom code?

     

    Also, welcome to Flow!! It's always fun learning new things! 

    There are some excellent training options to get to know the platform better. This is a great first introduction (the MS Learning Path for Power Automate) if you haven't checked it out yet:
    https://docs.microsoft.com/en-us/learn/modules/get-started-flows/

     

    Also, DynamicsCon (a virtual conference) just happened this month and I know there were some sessions on Flow (Power Automate). You can check out all of the recordings from the conference here: https://www.youtube.com/channel/UCMZvvyfdPh6rjyG0rLk6X-A

     

    Flow is fun, you just have to learn a new language 🙂 

    Let me know if there's anything else I may be able to help with.

     

    All the best,
    Heidi

  • Gocvindarajula Profile Picture
    Gocvindarajula 6 on at
    Re: Simple calculation with Flow - Total & Average of a training lists

    Hi Heidi,

     

    Thanks for the message. I though no one would respond to this! 

     

    Well, I have tried 'Calculated Field'. But it did not workout. 

    Because, If you see the last column '% of Completion' (i.e. This is a Calculated Field).

     

    My understanding is that, we cannot have 'Calculated Field' for a 'Calculated Field' 🙂

    Not sure about ' CDS/D365/a model-driven or canvas app'. But, I will search and find out more.

     

    I am not familiar with 'Flow' , so I am here looking for guidance.

    Do you have any reference documents to study and understand 'Simple Flow' creation?

    If 'Yes', please do share.

     

    Regards,

    Chandra

  • HeidiN Profile Picture
    HeidiN 34 on at
    Re: Simple calculation with Flow - Total & Average of a training lists

    Hi there! Have you thought about using calculated fields to do some of this logic? You can build a field and make it calculated to get lots of these sorts of equations. Here's some documentation from MS about some of the possibilities:

     

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields

     

    I'm sure you can do the same using Flow - but if you're working with CDS/D365/a model-driven or canvas app, using a field type is a lot easier and a better tool for the job! 

     

    Best of luck! 
    Heidi

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard