Unanswered

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

(0) Share

Report

Posted on by Gocvindarajula

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:

I have a list with all the fields like

(a) Training Title

(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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

HeidiN 34 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Gocvindarajula 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
HeidiN 34 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No