Integrate ArcGIS Data Pipelines in ArcGIS Enterprise with Microsoft Power Automate

[Bud]

As @Sarah_Hanson mentioned in a Pipelines question: Can an Enterprise Data Pipeline call a Power Automate flow (to send an email)?

Support for integrating ArcGIS Data Pipelines in ArcGIS Enterprise with Microsoft Power Automate is not possible today. This is only supported for ArcGIS Data Pipelines in ArcGIS Online currently.

Could enterprise pipeline functionality be added to the ArcGIS Enterprise Connector for Power Automate? To do the following: Call a Power Automate flow from an Enterprise Data Pipeline to send an email.

Details: A daily pipeline job to query if there are any construction projects in a EGDB FC where the  PROJECT_STATUS=FUTURE  and the DATE <= sysdate. If any records are found, then call a Power Automate flow to send a user an email.  In other words, Scheduled emailed reports in ArcGIS Pro/ArcGIS Enterprise (centralized; server-based, no-code).

Explanation:  The construction project was entered correctly at the time the data was initially entered, but now it's out of date. This situation could not be avoided using editing constraints like an attribute rule, since the information was correct at the time it was entered. The only thing that has changed is: time has passed. We need to be notified by email about this issue so we can edit/update the data.

Pipelines Idea: Call Power Automate flow from an Enterprise Data Pipeline to send an email

[AkshayHarshe]

@Bud Thanks for submitting the idea I will look more into it and what can be done. To start a power automate flow we will likely need a webhook in the Data Pipeline which can trigger. When Data Pipeline finished running, or something similar. But there could be other ways too. 

Help me understand this better but I think the your use case can be solvable using Power automate in general.

The construction project was entered correctly at the time the data was initially entered, but now it's out of date. This situation could not be avoided using editing constraints like an attribute rule, since the information was correct at the time it was entered. The only thing that has changed is: time has passed. We need to be notified by email about this issue so we can edit/update the data.

Is it possible for you to create a stand a lone flow on recurrence that can use time difference formula to find the records and send an email. you might need to create tracking if the email is already sent or not otherwise it will start sending emails every time the flow runs.