"},{"ID":318092,"user_firstname":"Russell","user_lastname":"Sands","nickname":"Russell Sands","user_nicename":"rsands","display_name":"Russell Sands","user_email":"RSands@esri.com","user_url":"","user_registered":"2022-09-09 13:45:17","user_description":"Russell Sands is a Solution Engineer on the Mapping, Location Services, and Analytics team, focused on real-time GIS, advanced analytics, and developer technology.","user_avatar":"
"}],"short_description":"Want to geocode Salesforce records using the ArcGIS World Geocoder? Now you can by leveraging the ArcGIS Connectors for Power Automate.","flexible_content":[{"acf_fc_layout":"content","content":"In this post, we will walk you through one of the new ways organizations can achieve these outcomes by harnessing the power of the ArcGIS World Geocoding Service using the ArcGIS Connectors for Power Automate<\/a>. Combining the ArcGIS World Geocoding Service and Power Automate<\/a>, Microsoft\u2019s low code\/no code Robotic Process Automation (RPA)<\/a> service, your organization can geocode Salesforce records without writing a single line of code.<\/p>\n"},{"acf_fc_layout":"content","content":" If geocoding is a new term for you, geocoding is: \u201cthe process that converts addresses and place names into coordinates\u201d. Put simply, geocoding is making sense of location information. It is the initial step for organizations wanting to visualize and analyze their data to make key decisions and obtain a competitive edge. Before your data can be visualized or analyzed, it must be assigned a unique spot on the Earth\u2019s surface, it needs a location. This location is a point or position representing the place and serves as the fundamental element for any geospatial display or analysis.<\/p>\n"},{"acf_fc_layout":"content","content":" In Power Automate, the first step is to create a new ‘Automated cloud flow<\/a>‘ using the Salesforce connector. The Salesforce connector<\/a> enables you to trigger a Flow in Power Automate when new records are added, or when existing ones are updated in Salesforce. By selecting the ‘When a record is created’ trigger, the Power Automate Flow listens for new records created in Salesforce. When a new record is added, the Flow starts automatically and performs the other actions in the Flow.<\/p>\n"},{"acf_fc_layout":"content","content":" If this is your first time creating a connection to Salesforce, you will be prompted to log in and allow Power Automate access to your Salesforce organization.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1706222,"id":1706222,"title":"Salesforce_Connect1","filename":"Salesforce_Connect1-e1662640583858.png","filesize":32319,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-e1662640583858.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/platform\/data-management\/geocoding-salesforce-records-with-arcgis-connectors-for-power-automate\/salesforce_connect1","alt":"A screenshot showing the Salesforce connector set to log in to the Production environment using v41.0 of the Salesforce API","author":"297282","description":"","caption":"","name":"salesforce_connect1","status":"inherit","uploaded_to":1706152,"date":"2022-09-07 14:26:11","modified":"2022-09-09 20:53:45","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":600,"height":415,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-e1662640583858.png","medium-width":377,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-e1662640583858.png","medium_large-width":600,"medium_large-height":415,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-e1662640583858.png","large-width":600,"large-height":415,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-e1662640583858.png","1536x1536-width":600,"1536x1536-height":415,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-e1662640583858.png","2048x2048-width":600,"2048x2048-height":415,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-673x465.png","card_image-width":673,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect1-e1662640583858.png","wide_image-width":600,"wide_image-height":415}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"image","image":{"ID":1706232,"id":1706232,"title":"Salesforce_Connect2","filename":"Salesforce_Connect2.png","filesize":38897,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/platform\/data-management\/geocoding-salesforce-records-with-arcgis-connectors-for-power-automate\/salesforce_connect2","alt":"A screenshot of Power Automate showing the log in window for Salesforce","author":"297282","description":"","caption":"","name":"salesforce_connect2","status":"inherit","uploaded_to":1706152,"date":"2022-09-07 14:26:43","modified":"2022-09-09 20:53:54","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1100,"height":495,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2.png","medium-width":464,"medium-height":209,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2.png","medium_large-width":768,"medium_large-height":346,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2.png","large-width":1100,"large-height":495,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2.png","1536x1536-width":1100,"1536x1536-height":495,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2.png","2048x2048-width":1100,"2048x2048-height":495,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2-826x372.png","card_image-width":826,"card_image-height":372,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect2.png","wide_image-width":1100,"wide_image-height":495}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"image","image":{"ID":1706242,"id":1706242,"title":"Salesforce_Connect3","filename":"Salesforce_Connect3.png","filesize":44987,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/platform\/data-management\/geocoding-salesforce-records-with-arcgis-connectors-for-power-automate\/salesforce_connect3","alt":"A screenshot showing Salesforce asking the user to allow or deny Power Automate to Access Salesforce","author":"297282","description":"","caption":"","name":"salesforce_connect3","status":"inherit","uploaded_to":1706152,"date":"2022-09-07 14:27:01","modified":"2022-09-09 20:54:34","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1100,"height":495,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3.png","medium-width":464,"medium-height":209,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3.png","medium_large-width":768,"medium_large-height":346,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3.png","large-width":1100,"large-height":495,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3.png","1536x1536-width":1100,"1536x1536-height":495,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3.png","2048x2048-width":1100,"2048x2048-height":495,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3-826x372.png","card_image-width":826,"card_image-height":372,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/Salesforce_Connect3.png","wide_image-width":1100,"wide_image-height":495}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" Note:<\/strong><\/em> Depending on your organization’s Salesforce security policies, you may need to work with your Salesforce Administrator to get the appropriate privileges to connect with an external application.<\/p>\n Now that you have established the connection between Power Automate and Salesforce, select the Salesforce object you want to geocode from the dropdown list. In this example we will be selecting the Accounts object.<\/p>\n"},{"acf_fc_layout":"content","content":" When working with a Salesforce object in a Flow, the object’s fields become available to other steps in your Flow as dynamic content. Every time a new record is created, the Flow is triggered and we can use the information in the new record’s fields to perform downstream actions. In the next section, we will use this dynamic content to geocode the new Account\u2019s records.<\/p>\n"},{"acf_fc_layout":"content","content":" To use the ArcGIS World Geocoder, add a new step to your Flow and search for the ArcGIS Connector for Power Automate\u2019s \u2018Find address candidate\u2019 action. For ‘Address’ and other location information, select the corresponding dynamic content representing your Salesforce object. Each time the Flow is triggered, the \u2018Find address candidate\u2019 action sends the address information from the newly created record to the ArcGIS World Geocoding service and obtains the latitude and longitude coordinates.<\/p>\n"},{"acf_fc_layout":"content","content":" In the same way that the fields associated with the Account became dynamic content, you can now use the results from the ArcGIS World Geocoding service as dynamic content in downstream actions. With this dynamic content, the Flow can update the new Account record’s Billing Latitude and Billing Longitude fields with the latitude and longitude values returned by the\u00a0 \u2018Find address candidate\u2019 action.<\/p>\n To complete this Flow, add a new step and search for ‘Salesforce’, then select the Salesforce ‘Update record (v3)’ action. Select the Object Type you want to update, and populate your fields with your dynamic content. The example below shows how to use ‘Update Record (v3)’ to update the Billing Longitude and Billing Latitude for the new Account record.<\/p>\n"},{"acf_fc_layout":"content","content":" And that’s it! In three steps, you have created a Power Automate Flow which provides a single source of truth for geocoding in your CRM and GIS, without writing a single line of code!<\/p>\n"},{"acf_fc_layout":"content","content":" When using the Salesforce and ArcGIS Connectors for Power Automate, there are some key Salesforce considerations to be aware of. Because you are connecting to Salesforce with Power Automate, you will need to ensure that your Salesforce organization is configured with the correct security and permissions to edit Salesforce objects from an external application. You may also consider saving the results from the ArcGIS World Geocoding Service in a custom field rather than in one of the standard fields for your record. Your Salesforce administrator can help you determine the best approach for your use case.<\/p>\n"},{"acf_fc_layout":"content","content":" If your organization does not have ArcGIS Online<\/a>, it is still possible to geocode Salesforce objects in three easy steps. Using the ArcGIS PaaS Connector for Power Automate<\/a>, the Flow can access location services through the ArcGIS Platform<\/a> as seen in the image below.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1707332,"id":1707332,"title":"GeocodeWithPaaS","filename":"GeocodeWithPaaS-e1662748463949.png","filesize":78163,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-e1662748463949.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/platform\/data-management\/geocoding-salesforce-records-with-arcgis-connectors-for-power-automate\/geocodewithpaas","alt":"A screenshot of a the complete Flow when using the ArcGIS Platform","author":"297282","description":"","caption":"Using the Power Automate Connector for PaaS to geocode the Salesforce record.","name":"geocodewithpaas","status":"inherit","uploaded_to":1706152,"date":"2022-09-08 12:50:13","modified":"2022-09-09 20:59:35","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":500,"height":769,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-e1662748463949.png","medium-width":170,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-e1662748463949.png","medium_large-width":500,"medium_large-height":769,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-e1662748463949.png","large-width":500,"large-height":769,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-999x1536.png","1536x1536-width":999,"1536x1536-height":1536,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-e1662748463949.png","2048x2048-width":500,"2048x2048-height":769,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-302x465.png","card_image-width":302,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/GeocodeWithPaaS-703x1080.png","wide_image-width":703,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" The ArcGIS Platform is a location-focused platform-as-a-service (PaaS) offering that provides direct access to Esri\u2019s<\/a> powerful location services. Designed for developers that need to integrate location capabilities into their apps, business systems, and products, the ArcGIS Platform provides simple, transparent, consumption-based pricing that allows you to pay only for what you need and scale as your needs grow. By signing up for an ArcGIS Developer<\/a> account, you can create API Keys<\/a> to authenticate to the ArcGIS World Geocoder and other pay as you go services.<\/p>\n With no restrictions on where you store or consume stored geocoding results, the ArcGIS Platform is the ideal solutions for organizations who don\u2019t use ArcGIS today to leverage the power of the ArcGIS World Geocoder.<\/p>\n"},{"acf_fc_layout":"content","content":" Following this process will allow you to easily geocode your Salesforce records without writing a line of code regardless of your Organization having ArcGIS Online or not. This is also just the start of what you can do with the ArcGIS Connectors for Power Automate – what will you do?<\/p>\n"}],"related_articles":[{"ID":1439122,"post_author":"297282","post_date":"2021-12-16 13:17:06","post_date_gmt":"2021-12-16 21:17:06","post_content":"","post_title":"ArcGIS Connectors in Power Automate","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"arcgis-connectors-in-power-automate","to_ping":"","pinged":"","post_modified":"2021-12-16 14:17:24","post_modified_gmt":"2021-12-16 22:17:24","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1439122","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"16","filter":"raw"},{"ID":1125032,"post_author":"6161","post_date":"2021-01-27 10:00:32","post_date_gmt":"2021-01-27 18:00:32","post_content":"","post_title":"Introducing ArcGIS Platform","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"introducing-arcgis-platform","to_ping":"","pinged":"","post_modified":"2024-04-12 04:08:07","post_modified_gmt":"2024-04-12 11:08:07","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1125032","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1160992,"post_author":"7191","post_date":"2021-03-12 16:24:43","post_date_gmt":"2021-03-13 00:24:43","post_content":"","post_title":"ArcGIS Platform: Build innovative solutions with high-quality location services","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"arcgis-platform-build-innovative-solutions-with-high-quality-location-services","to_ping":"","pinged":"","post_modified":"2024-04-12 04:06:25","post_modified_gmt":"2024-04-12 11:06:25","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1160992","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/LegoBlocks_Small.jpg","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/09\/LegoBlocks.jpg"},"yoast_head":"\nCreating the Power Automate Flow<\/h1>\n
Creating a new automated cloud Flow in Power Automate
Using the ArcGIS Connector for Power Automate to Geocode your Record<\/h2>\n
Salesforce Considerations<\/h2>\n
What if my Organization Doesn’t Have ArcGIS?<\/h2>\n
Summary<\/h2>\n