I'm trying to find a way to send scheduled emailed notifications based on GIS data.
- I want the automation to be server-based so that the mechanism is robust/reliable. I don't want to use Windows Task Scheduler on my local PC, which is what is used for scheduled geoprocessing tools.
- I'm not in IT, so I can't manually set up scheduled automations on a server (i.e. Windows Task Scheduler, Oracle Scheduler, or SMTP). My organization doesn't have ArcGIS Notebook Server, and even if they did, as non-IT staff, I wouldn't have access to it. We don't have 3rd-party automation software like FME. And I don't have Windows admin credentials for installing software on my PC.
- But what I do have access to is Microsoft Power Automate via Office 365 (not the Desktop version of Power Automate).
- And I have ArcGIS Pro, including SDE/Oracle GDB connection files: an OS Authentication connection file and a database connection file to a specific Oracle user/schema/data-owner.
Question:
Is there a way to use Microsoft Power Automate (possibly in conjunction with Python and my SDE connection files) to send scheduled emailed notifications?
For example, on a nightly schedule, I want a server (Power Automate) to check for records in a GIS/SDE query. If the query finds any records, then email me a notification.
So, if there are construction projects in a FC where the status is FUTURE and the date <= sysdate, then those records are out-of-date, so I need the system to tell me about them so I can fix them.
Is there a way to do that?
