In June 2023, the ArcGIS for Microsoft 365 component documentation was consolidated into a single site to help you see how this product suite is integrated into all of your favorite Microsoft business products.

Now that you are familiar with the new documentation, the August 2023 update is here with many significant enhancements, bug fixes, and new tools to explore.

The following sections detail these updates, per component.

ArcGIS for Excel

The following are updates to ArcGIS for Excel:

• You can use the Zoom To or Select tools on the Map Data tab to  from their corresponding row, cell, or cell range in the Microsoft Excel spreadsheet.

• You can now add and edit an ArcGIS Online or ArcGIS Enterprise layer attribute table in an Excel worksheet. The changes you make in Microsoft Excel can immediately be updated in the editable fields in the data hosted in your organization. Inversely, click Refresh on the layer when you have it open in Excel and view the changes you made to the remote-hosted layer in ArcGIS Online or ArcGIS Enterprise.
  • The data types that can be written to a cell are number, text, logical (true and false), or error value. When you type input in a cell, Microsoft Excel automatically detects and assigns the type.

Learn more about data types, formats, and categories

Learn more about comma, decimal point, and semicolon separators

See the ArcGIS blog article for more information.

• You can use the ENRICHBYADDRESS function to get enriched demographic information about the people, places, and businesses in a specific area or within a certain distance or drive time from an address. The default distance is within a one-mile radius of the point.
• Questions around Pivot tables and others are answered in the updated FAQ topic.

ArcGIS for Power BI

The following are updates to ArcGIS for Power BI:

• The Basemap tool is now more intuitive to use. Previously, settings for this tool were managed from the Visualizations pane. Now, when the Basemap tool is turned off and you drag data into a Power BI field well, the Basemap tool is automatically turned on, allowing you to update the basemap. Click Reset to default or turn off the Basemap tool on the Format visual tab in the Visualizations pane or clear the field well to remove the Basemap tool from the map tools.
• When you select features on a time-aware layer and run the time animation, only the features visible during the specified time period are visible when playing the animation.
• Additional support, bug fixes, and improvements to the user interface have been made.

ArcGIS for SharePoint

The following are updates to ArcGIS for SharePoint:

• Use the Reset connection button to remove a map’s content or switch your ArcGIS organization or portal connections.

• Use new PowerShell commands to edit ArcGIS connections and control ArcGIS organization access.
• Installation and management documentation for ArcGIS for SharePoint has been updated.
• Map sharing is now disabled for Viewers, and Contributors can hide share options from Viewers.

ArcGIS for Teams

The following are updates to ArcGIS for Teams:

• The Options tab layout in the personal (private) scope installation has been improved.

• Additional search item types are available to open in ArcGIS for Teams as you search.

• Additional support, bug fixes, and improvements to the user interface have been made.

ArcGIS Connectors for Power Automate

The following are updates to ArcGIS Connectors for Power Automate:

• ArcGIS Connectors for Power Automate now includes the ArcGIS Enterprise connector to access and use certain actions.

• The Find address candidates action now provides multiple results, ranked by match score, containing location information about an input.
• The Find address candidates and Geocode addresses actions now support custom geocoders.
• The token refresh issue that caused flows to break has been resolved.

Additional resources

You can read the latest blog articles, interact with experts, take a survey, learn about ArcGIS for Microsoft 365 components, get peer-to-peer feedback, and find answers to software questions on the Esri Community site.

Visit the video site, new product page, and ArcGIS for Microsoft 365 Esri Community pages for the latest change logs and blog articles:

• ArcGIS for SharePoint
• ArcGIS for Excel
• ArcGIS for Power BI
• ArcGIS for Teams

ArcGIS Connectors for Power Automate

About the authors

Rebekah Folsom

(she/her) Principal Product Engineering Writer on Esri's Product Writing Team, Portland, OR, USA. A lifelong word nerd, I write content for ArcGIS for Microsoft 365 components, Esri Demographics and ArcGIS Places data capabilities, and Esri's GIS Dictionary.

Connect:

Zoya Domashnev

Zoya is a Product Engineering Writer for ArcGIS for Microsoft 365. A lifelong Yinzer, she is passionate about public transit, technology, and urban planning. She has been with Esri since 2022, loves cats, and likes to say she's somewhat like the "Carrie Bradshaw of maps".

Connect:

Mrinmayee Bharadwaj

Mrinmayee "Minu" Bharadwaj has been with Esri since 2015. She is a Product Engineer: Documentation for Microsoft Integration apps. She was previously a Writer in Professional Services for ArcGIS Maritime and ArcGIS Aviation. She holds degrees in Psychology, English and Geography. She's passionate about technology and languages, and is fluent in French and German. She loves exploring new places, hiking, movies, books and a solid cup of tea.

Connect: