topic Create Features from Salesforce XY Data in ArcGIS Connectors for Power Automate Questions

Create Features from Salesforce XY Data

BenClark — Tue, 05 Dec 2023 19:04:05 GMT

Hi all,

I'm new to both Salesforce and PowerAutomate, and am trying to figure out the best way to automatically convert records from the former into GIS features upon initial data entry. I found a very handy tutorial here on how to automatically add XY data to a new Saleseforce record, but what I can't sort out is how to then actually turn that data into a mappable feature.

I very well could be overlooking something here, but so far I've not been able to wrap my head around that last crucial step...

Thank you!

-Ben

Re: Create Features from Salesforce XY Data

TL2 — Tue, 19 Dec 2023 20:57:05 GMT

Can you just use Add XY Data in Pro? What am I missing?

Re: Create Features from Salesforce XY Data

AnthonyLatini — Thu, 28 Dec 2023 00:00:28 GMT

@BenClark @TL2 - Hi there. I think where the hang up might be is passing the geometry value in the Create a record in a feature layer action.

Let me know if the following steps help out and if this is what you were looking to do in your flow. You can set this flow up to run manually or to run it as a trigger as mentioned in the blog post (When a record is created in Salesforce).

1. In the Create a record in a feature layer action, paste the following code into the geometry field.

{ "x": INSERT_YOUR_LONGITUDE_FIELD_FROM_SALESFORCE_ACTION, "y": INSERT_YOUR_LATITUDE_FIELD_FROM_SALESFORCE_ACTION, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }

2. It should look something like this after it is inserted and you have selected the layer you want to update.

3. Run the flow and the new features should appear on the map.

Re: Create Features from Salesforce XY Data

Cmurchie — Sat, 25 Jan 2025 17:02:42 GMT

This is phenomenal Anthony - it cut through a lot of work on my end. Powerful feature with so little documentation...

One quesiton - how would I have the feature created / populated with other fields coming in from my salesforce action, not just the lat/long For instance , fearture names or other Salesforce fields?