Learn how you can use Xpath, Select and Join to calculate an exponential. In Power Automate, whilst you can multiply two numbers together with the Mul() expression, it is not possible to natively calculate and exponential or power of X^Y.
I demonstrate how you can build an efficient flow to calculate the result of an exponent.
The guide below is a reference for the workflow expression functions used in Logic Apps and Power Automate.
https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
The challenge my colleague faced was not with Power Automate’s limitations but in the JSON that was returned by the marketing platform. There wasn’t anything we could do to change that so we had to find a way to work with whatever it returned. Remember our goal: Create a new contact with email in D365 based on what is returned from the marketing platform.
https://forwardforever.com/xpath-power-automate-integration/