Upgrade ArcGIS Enterprise Actions/Trigger

[Kacy_Beck]

I've come across an obstacle in Power Automate with the ArcGIS Enterprise action. My goal is to create a flow to send an email (if certain conditions are met- like if the field Needs_GISupdating is equal to Yes)(this is for a GIS audit) and to include the dynamic content in the email. However, it would appear that after having been on a support call with Esri, that it is a limitation with the Enterprise action. but it isn't with the ArcGIS Online one. I've attached screenshots. Basically, the Fetch Updates, Changes, or Deletions from Feature Layer is not giving me the option to choose which field to pull that information from in my feature layer. Therefore the Output in the Fetch Updates,.. action returns the item section (where my attributes for the dynamic content would be) as empty, therefore not allowing me to continue with my flow. Anyone know if there's a workaround? Or am I missing something? If not, then an upgrade to this would remove my limitation with moving forward with this audit project. 

[CalvinHarmin]

I wonder if you might want to use the REST API with an HTTP connector (premium license required) using the GET method. Here's an example of how I query an AGOL hosted feature layer. The REST_url is just the Feature Service or Hosted Feature Layer REST endpoint that includes the /0 on the end to specify the relevant layer id within your service.

The output JSON 'body' of this action will have a 'features' value, which is an array. Each item in this array will be the JSON object for a feature that is returned that matches your where query parameters; each of these feature items includes an 'attributes' JSON object and a 'geometry' JSON object. In my case I'm just getting the attributes for a single, specific objectid, so my 'features' array has only 1 item that I need to parse for further processing.

But your where query could include both the objectid(s) from the webhook trigger, AND if it matches your Needs_GISupdating = 'Yes' requirement. If there are multiple features, you can create an Apply to Each condition to process each feature or send an email for each feature. Or you can parse each item and append it to an array or something if you want to send one email with information about all of the relevant features at once. 

I can try to assist more if you want to go this route to query your data. 

"features": [

            {

                "attributes": {

                    "objectid": 48847,

                    "otherattributes": "yada yada"

                },

                "geometry": {

                    "x": -8771208.883218553,

                    "y": 4241626.251971537

                }

            },

           {

                "attributes": {

                    "objectid": 48849,

                    "otherattributes": "blah blah"

                } ... and so on

        ]