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
Helper I
Helper 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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (34,918)