Latest Contributions by AkshayHarshe

Introduction ArcGIS for Power Automate is a powerful tool that enables you to automate workflows by integrating ArcGIS with various services. One significant functionality is the ability to add data to feature layers. However, as your data processing needs grow, you might find that migrating to batch operations becomes essential to improve efficiency and manage larger datasets effectively. What are the new batch actions? In 2024.2 release we introduced Batch actions that allow us to add or update multiple features in a single request. The following actions are added to the list Add records to a feature layer (batch) Update records in a feature layer (batch) These actions will take Array of Features as their input. Notice the difference between Update a record in a feature layer Inputs vs Update records in a feature layer (batch)     Appropriate JSON structure for the Array of features can be found here. To extract the schema of your Feature layer, access the REST endpoint of your ArcGIS server service and query the features at "/server/rest/services/FeatureService/<layer>/query". For ArcGIS Online, open Item details for the layer you are trying to query under item details and view the URL. Once at the query endpoint form, under Where, use 1=1 (or an OBJECTID you know) with Out Fields set to * and Format set to JSON. If your data originates from sources other than a feature layer, such as Excel or a database where geometry information is stored in a text column, you must rename the column to "geometry" for the Batch actions to recognize it in Power Automate. Alternatively, you can create the required JSON structure using Power Automate built-in actions like Select, Compose, and Parse JSON from Data Operations, which will be useful. Here is a sample JSON structure. [{ "geometry": {"x": 1234,"y": 1234}, "attributes": {"name1": "value1", "name2": "value2"} }, { "geometry": {"x": 1234, "y": 1234}, "attributes": {"name1": "value1", "name2": "value2"} }] Are batch actions right for you? When working with single feature operations such as `Create/Update a record in a feature layer` you typically add one or a few features at a time to your feature layer. This method is straightforward and can be sufficient for small-scale data additions or updates. There is no need to change the existing workflow as there are no performance gains. Using these actions within a "For Each" loop becomes less efficient when handling a large number of records that need to be created or updated. It is advisable to consider migrating to batch actions in the following scenarios: Updating dozens or thousands of records. The flow is set to run frequently with numerous features. Working with feature arrays can be a better alternative to configuring each field in a form for single record actions, particularly when dealing with feature services that contain many fields. Performing copy operations. ... View more

We are pleased to announce the latest updates and enhancements to the ArcGIS for Power Automate connectors, released in the first week of April, 2025. The released version is 2025.1. This release introduces a comprehensive array of enhancements and bug fixes. ArcGIS Online and Enterprise connectors were released and following updates doesn't apply the ArcGIS PaaS connector. Key Update BUG-000169725: Authentication to ArcGIS Online through ArcGIS Connectors for Power Automate workflows frequently fails and returns the error message, "Authentication failed. Your session has expired." This issue, which affected a significant number of Esri users, has been successfully resolved along with updates to token exchange mechanism the error messaging. This should provide relief for ArcGIS Enterprise 11.3 and 11.4 users who were affected by this. No further actions are required by users. Important Bugs Fixes An issue with the "Update a Record in a Feature Layer" action has been resolved. Previously, a "STRING" Unique ID was incorrectly treated as a "NUMBER," resulting in an error: No item was found that matches the query <fieldname> = <value> … Action name was corrected from “Update records to a feature layer (Batch)” to “Update records in a feature layer (Batch)” BUG-000173694 An error message returns when using the 'Delete a record from feature layer' action with a referenced feature service in the ArcGIS Enterprise connector for Power Automate was resolved. Using the 'Delete a record from feature layer' action with a referenced feature service from ArcGIS Enterprise resulted in the error below, however, the record was deleted from the feature layer. "ResponseSwaggerSchemaValidationFailure. The API 'arcgisenterprise' returned an invalid response for workflow operation 'Delete_a_record_from_feature_layer' of type 'OpenApiConnection'. Error details: 'The API operation 'DeleteItemInFeatureLayer''. BUG-000170950: The problem where leading or trailing zeros were trimmed when inserting a number into a string field while using the 'Create a record in a feature layer' action in ArcGIS Connectors for Power Automate has been addressed. These updates underscore our commitment to enhancing the functionality of ArcGIS for Power Automate connectors, ensuring that users experience a seamless and efficient workflow. We look forward to bringing you more exciting updates and features in the future. Please feel free to reach out and comment ... View more

We are pleased to announce that we have fixed issue BUG-000174431 where Power Automate was throwing an error code 1000 with the message "Conversion failed when converting date and/or time from character string." Power Automate is now resolved and should be available in production. This fix affects the following actions: Create a record in a feature layer Update a record in a feature layer Even though the input field is text, the epoch entered should be without quotes, e.g., 1740433032729. Other text inputs are possible in the format of MM/DD/YYYY, etc. For specifications, please refer to the Add Features  and Feature Object. When the input date is not in the epoch time, it is recommended to use the "Convert date and time format" action. Thank you for your patience and understanding ... View more