Since you're using PowerPlatform you can prob easily do that with Microsoft's Power FX, built - I believe - especially for this.
https://docs.microsoft.com/en-us/power-platform/power-fx/ove...
Power FX has a level of abstraction squeezed between MS's other options (excel formulae,power query M/DAX, Powershell, C#).
It gives the impression of a pet project rather than something users actually asked for.
Power FX has a level of abstraction squeezed between MS's other options (excel formulae,power query M/DAX, Powershell, C#).
It gives the impression of a pet project rather than something users actually asked for.