Unable to retrieve feature layers when setting up ArcGIS Connector in Microsoft Power Automate

[CMSchelde]

I'm experiencing the same issue that this Post discusses and I was wondering if there were any updates on this issue.

Post link - Unable to retrieve feature layers when setting up ArcGIS Connector in Microsoft Power Automate

When I use Enter Custom value  and add the Feature Layer Id - 5b442d3f84bd48de84ea2a981fa8a013layerid0 - it appears to connect, but then I can't  access any of the Dynamic Content from the Feature Layer even when I use the Fetch Data steps. The dynamic content is not visible and then I get an error message that can connect using the Feature Layer Id either.

I have checked my feature layer and it has the correct settings (info in attached PPT).

The strange thing is there is another user in our organization that does not have any problems accessing his Feature Layers list via the ArcGIS Connectors. He owns a total of 14 Feature Layers and I own 261.

Thanks in advance and any assistance/insights.

Best regards,

Colleen Madigan Schelde

[RobertAnderson3]

Does the layer not appear in the drop down list for the connector? Do ANY layers show up here?

My first thought is always to make sure you're logged into the connector with the same account that has permissions to the layer you're trying to access, it should show up.

While not a Survey123 instance, I have found that in Survey123 if you have groups with a blank name value it prevents the dynamic content from loading into Power Automate which was really annoying, maybe something similar is related here?

[CMSchelde]

Thanks Robert 

See my response to Akshay's post.  I was not using the correct Feature Layer ID info. This format worked

https%3A%2F%2Fservices6.arcgis.com%2FrQtYP0Thi23gg8bz%2Farcgis%2Frest%2Fservices%2Fservice_5b442d3f84bd48de84ea2a981fa8a013%2FFeatureServer%2F0

Now I can access the Feature Layer data payload, but for some reason the e-mail won't send like it does in my Survey123 Connector flows.  I need to use the ArcGIS Connector because the data payload is too big for this survey. 

[AkshayHarshe]

@CMSchelde If you own the layer please try using `Enter value` and paste in the url of the feature layer. Power Automate is sometimes quite slow retrieving the feature layers especially if the list is large. 

Any ArcGIS trigger must be used with `Fetch updates, changes...` Action right next to it to retrieve the features that are just updated. `Get data from feature layer` action is helpful to query data from the feature layer and not the changes coming in from a trigger. 

Hope that helps! Let us know if you have further questions.

[CMSchelde]

Thanks Akshay 

I found that my custom value was not formatted correctly, so I used this instead (thanks to my colleague Arek in Poland -

https%3A%2F%2Fservices6.arcgis.com%2FrQtYP0Thi23gg8bz%2Farcgis%2Frest%2Fservices%2Fservice_5b442d3f84bd48de84ea2a981fa8a013%2FFeatureServer%2F0

I have followed all the steps that are in this Blog from Esri UK - Getting to grips with ArcGIS Connectors for Power Automate - Resource Centre | Esri UK

That helped me to connect to my Feature Layer data payload!! BIG success, but now the e-mail is still not sending. I have re-published the survey and have set in the Feature layer - Keep track of changes to the data (add, update, delete features) as checked. 

Not sure what more to do and have sent an e-mail directly to Sean McGinnis at Esri.

Colleen Madigan Schelde

Nexel/Andel

[AkshayHarshe]

@CMSchelde I am sorry to hear that the email is still not being sent.

You mentioned a survey, what trigger are you using to retrieve changes?

If you are using `When a record is created in a feature layer` trigger for a survey from Survey123 then I will advise you to switch the trigger to `When a survey response is submitted` and select the survey.

I believe trigger is newer to the blog you quoted.

Also, is the trigger running? (do you see the runs in PA?) If so can you check what is the response for the `Fetch updates deletes, or changes` action. (you can click the `Raw Output` button to see what is returned)

Let me know and I will be more than happy to troubleshoot.