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.
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?
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:
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!
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.
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:
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,
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!