How to trigger Pipeline after adding items to SharePoint list

[zilka193]

Hello,

I have built a pipeline that starts with a Dataflow Gen2 to pull SharePoint List into a Fabric Lakehouse. 

Scheduling (or manually triggering) this pipeline works well. The idea is to trigger it automatically after new items were added to the list. I cannot find any info on how to do this and would like to hear from the community if (and how) this works.

Thank you!

[lbendlin · Accepted solution]

Use a Power Automate trigger "Item added to list"  and a HTTP call to start the pipeline

Trigger Microsoft Fabric Data Pipeline using Power Automate - Hat Full of Data

Warning: You need to debounce that to avoid the 429s

[v-bmanikante]

Hi @zilka193,

We would like to follow up to see if the solution provided by the super user @lbendlin  resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
B Manikanteswara Reddy

[v-bmanikante]

Hi @zilka193,

We would like to follow up to see if the solution provided by the super user @lbendlin  resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
B Manikanteswara Reddy

[Srisakthi · Accepted solution]

Hi @zilka193 ,

As of now there is no direct trigger is available in Fabric for automating files arrival in sharepoint list. But there is an option for triggering pipeline automatically for other sources like ADLS, Onelake, Job events, Workspace events.

As @lbendlin  mentioned you can leverage power automate

Regards,

Srisakthi

[v-bmanikante]

Hi @zilka193,

We would like to follow up to see if the solution provided by the super user @lbendlin  resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
B Manikanteswara Reddy

[lbendlin · Accepted solution]

Use a Power Automate trigger "Item added to list"  and a HTTP call to start the pipeline

Trigger Microsoft Fabric Data Pipeline using Power Automate - Hat Full of Data

Warning: You need to debounce that to avoid the 429s