I want to use ArcGIS Enterprise Data Pipelines to query EGDB records that meet certain criteria and email users if any records are found.
In this case, I don't want to use a third-party platform for email, like Power Automate, because that kind of integration is more fragile than staying within a single product like Pipelines. I need my automations to be 100% reliable and as simple as possible.