cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CMG
Regular Visitor

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

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

 

 

3 REPLIES 3
HeidiNeuhauser
Advocate I
Advocate I

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-calcula...

 

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

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

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,513)