ArcGIS for Power Automate - v2022.1.6 - Change log and updates (August 29, 2022)
ArcGIS for Power Automate is updated regularly to provide new features, improved speed and usability, and bug fixes. The 2022.1.6 update is a quality release. Performance improvements and bug fixes have been made for the following features.
This release will start deploying between August 29th, 2022, and August 30th, 2022. It may take up to 48 hours to push out to all regions (up to two weeks for government-level sites).
If you do not see the changes, you may need to clear your cache and restart your web browser to see the changes in Power Automate.
As always, please let us know of any improvements or issues you want to chat about.
---
Credit consumption
A bug was identified in the ArcGIS for Power Automate connector when using the geoenrichment action. Originally, when a flow was created using this action, there was a miscalculation for the amount of credits needed to complete the action.
As an example, the following flow is using an address column from a SharePoint list. In this list, there are five addresses. I created a 30-minute drive time buffer around each of those addresses and picked a variable to investigate.
Prior to this release, there were instances where the geoenrichment process miscalculated the results and thus overcharged the credits to the ArcGIS Online organization.
Credit consumption in v2022.1.5.
Credit consumption in v2022.1.6.
We will keep a close eye on credit consumption for all of the other actions in our connector and make any necessary fixes if we see something out of the ordinary.
Creating a feature layer from a SharePoint list
In ArcGIS for Power Automate, you can create a feature layer from a wide range of sources. One of the most common sources for data in the Microsoft ecosystem is SharePoint. Recently, there was a change in SharePoint that changed the names of columns under the hood of a SharePoint list. These changes seem to apply to lists that were created from an Excel table.
For example, below is a list that I created from an Excel file. I have a name for each of my columns; Address, Variable.
However, when I dig into the list settings, I see that the fields are named something completely different; Title, field_2. I can see this at the end of the URL.
This was causing some unwanted behavior in our connector when attempting to search for a column named "Variable". This was quite noticeable when attempting to create a feature layer from a SharePoint list. We have now fixed this issue. You can now use the names of the fields from a SharePoint list and the flow will succeed.
Creating a feature layer using this method in v2022.1.5.
Creating a feature layer using this method in v2022.1.6.
----
As we continue to move toward the unified experience across all ArcGIS for Microsoft 365 visuals, we would love to hear your feedback, whether it be an idea or if something is broken. Having open communication about the visual and how we can improve will keep us moving forward and paving the way for GIS in the Microsoft 365 ecosystem.