Power Automate already has Power Query but just for SQL Server. It would be very powerful to add a Data Operation called "Transform an Array". Power Query has the functions needed to accept a JSON array (i.e., Json.Document) and return an array back to the Flow (Json.FromValue). Transforming an array currently in Power Automate is very limited, and fully leveraging Power Query in Power Automate would be a great capability addition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.