Add a Power Automate Activity to Fabric Data Factory Pipelines

In the world of Microsoft low-code/no-code, Power Automate has been referred to as the glue that holds Power Platform solutions together. With Fabric, there are occasions where activities need to be performed in areas not supported by Fabric, and Fabric solutions may even have dependencies on data fetched or produced by Power Automate. While there are HTTP-based approaches out there, this isn't low/no-code friendly and also introduces potential security risks if not properly handled.

Please add a built-in Power Automate activity that let's users trigger Power Automate flows and consume the response values from Power Automate flows.