[Automation Kit - Feature]: User defined Return on Investment (ROI) calculation

[Grant-Archibald-MS]

Is your feature request related to a problem? Please describe.

The current return on investment calculations are defined in the Automation Kit as part of a Power Automate Flow

While this is low code changes would require the use of an unmanaged layer and make future updates more difficult.

Describe the solution you'd like

Provide an extensibility model to the ROI calculations that allow administrators of the Automation Kit to define organization specific rules for Return On Investment calculations.

Could this be expressed as a Power Fx function that allows for greater customization of the expected return on investment?

Provide custom user defined functions to simplify the ability to query data from Dataverse tables

Describe alternatives you've considered

Creation of unmanaged layers to change the ROI calculation process

Additional context?

No response

AB#508

[Grant-Archibald-MS]

Possible PowerFx function that could calculate TotalCost per year for an Automation Project. This calculation could be updated based on the values of ThisItem for the Automation Project

Set(ProcessFrequencyValue,Switch(ThisItem.ProcessingFrequency,
"Daily",251,
"Hourly",2008,
"Weekly",52,
"Monlthy",12,
"Quarterly",4,
"Yearly",1));
Set(TotalCostPerYear,
ThisItem.AverageHourlyCostPerFTE
* ThisItem.NumberOfFTENeeded
* ThisItem.TotalProcessingTimeInMinutes
* ProcessFrequencyValue)

[Grant-Archibald-MS]

Extending the idea to Actual calculation

Set(FlowSessions,GetFlowSessions(ThisItem, "Success"));
Set(Actual,CountRows(FlowSessions)ThisItem.TimeSavedPerRunThisItem.AverageHourlyCostPerFTE));

Leverage user defined functions like GetFlowSessions to get the FlowSessions that have successful outcome.

Using that function result work out the Actual cost by counting the number of results and but the TimeSaved Per Run and the cost saved compared to manual work

[Grant-Archibald-MS]

Apart from Time Saved per run look at extend with:

• Work Queue - Number of time in queue, average time in queue, number of queue failures
• Custom Fields - For example Risk mitigated

[Grant-Archibald-MS]

Look to extend calculation of value and complexity calculations using Dataverse Accelerator to implement Power Fx functions using Dataverse Plugins