We are wanting to use either Make or Microsoft Automate to trigger some changes in the fields of other hosted feature layers when a survey 123 is submitted. I'd love to hear your experience with either company and what you use it for.
We use Make extensively for generating and emailing reports based on Survey123 forms, but also triggering edits of other fields and features using HTTP POST requests through Make as well. It's worked extremely well for us.
We dabbled with Power Automate, but our government license didn't seem to have access to all the features, so we went with Make instead.
When you say edits of other fields, do you mean that it triggers edits of fields in the tables of feature layers? I'm hoping to be able to automatically change a field in our Requests layer from "Submitted" to "Assigned" when a survey 123 assignment survey has been submitted for the request.
Sadly our production workflows relying upon the ArcGIS for Power Automate Connector have been unstable for the last month. We have finally gotten esri to create BUG-000163195 in order to address the issue:
The 'Fetch updates, changes, or deletions from feature layer' action in Microsoft Power Automate returns a Null objects for single updates to Feature layers
Thank you for the feedback. That is good to know.
@ahargreaves_FW @RachaelMurtaugh - Good afternoon.
I wanted to let you know that we have pushed an update to the ArcGIS Connector in Power Automate to fix one of the two issues that have been reported in multiple areas (and thought it would be good to post in this thread). I will be making a larger post about this shortly for the whole board to see. 😀
This issue has been tested extensively and appears to be resolved. This fix has been deployed to production.
NOTE: The issue with empty arrays is still under investigation and has not been resolved in this push.
Please let me know if you have any questions or if you see any other additional unwanted behavior.
@AnthonyLatini thanks to you and the team for this fix. So far we're seeing expected results...