Forum Discussion

Venkata960's avatar
Venkata960
Copper Contributor
Aug 23, 2022

Trigger pipeline on Approval

Hello,

 

I have a report which generate after running a pipeline, and I would need to append these records into a history table upon client approval. So, I need to use either PowerBi or Sharepoint to show this report to the client and get approval. So, I have this plan, Can someone please help me if this is doable, if yes, how to achieve it? if not please suggest changes.

 

1. Show the report in either PowerBI or SharePoint, and have buttons Approve/Reject. 

2. If the client clicks on Approve, it should trigger a pipeline using the Logic app, with necessary parameters passed. 

 

How to link buttons and logic app?

 

 

1 Reply

  • LukeJMadden's avatar
    LukeJMadden
    Brass Contributor
    Hello Venkata,

    Yes, it is definitely possible to trigger a pipeline from a button click in Power BI or SharePoint using a Logic App. Here's a high-level overview of how you can achieve this:

    In Power BI or SharePoint, create a button and set up an action to be triggered when the button is clicked. For example, you can use Power Automate (previously known as Flow) to create a flow that runs when the button is clicked.

    In the Power Automate flow, you can use the "HTTP" action to call the Logic App's trigger URL and pass in the necessary parameters. You can use the "Response" action to check the result of the Logic App trigger and perform any additional actions if needed.

    In the Logic App, you can use the "HTTP Request" trigger to receive the HTTP request from Power Automate. You can then use the necessary actions and connectors to trigger the pipeline with the required parameters.

    I hope this helps! Let me know if you have any further questions.

    Kind regards,

    Luke Madden

Resources