topic Re: Pulling Attribute Data in ArcGIS Connectors for Power Automate Questions

Pulling Attribute Data

NickCressman — Tue, 22 Mar 2022 15:46:48 GMT

Hi,

I'm currently trying to evaluate if I can use Microsoft power automate the same way as Integromat/Make. I've been trying tirelessly to get to the feature layers attribute data like you can with integromat/make as shown in the video from dev summit 2021. I have deployed a solution that works flawlessly in Make based on featureupdates where I can include attribute data in an email from a specific field. Any help or documentation would be greatly appreciated as I'm evaluating which platform to use.

Thanks in advance,

https://www.esri.com/videos/watch?videoid=D9PMC2yGJbA&title=getting-started-with-hosted-feature-layer-webhooks

Re: Pulling Attribute Data

Anonymous User — Tue, 22 Mar 2022 18:22:13 GMT

@NickCressman Yes, this is possible. I've published a blog post that shows how to configure a flow (in the context of ArcGIS Field Maps) that sends an email.

https://www.esri.com/arcgis-blog/products/field-maps/field-mobility/use-webhooks-to-automate-workflows-in-arcgis-field-maps-with-power-automate/

BTW, Field Maps has an app in Integromat that greatly simplifies using hosted feature service webhooks. We're still sorting through some issues with the Make support team - it's not working in Make after the migration. Anyway, it's not specific to Field Maps - you can use it for any hosted feature layer that supports webhooks.

Re: Pulling Attribute Data

NickCressman — Tue, 22 Mar 2022 18:28:04 GMT

@Anonymous User I actually followed your post and completed it. My only question is how do you break out the fields like make. If you look at the image below I can pick what field i want in make to include in my email that I send. This is important as the day of the week assigned is what needs to go out in the notification and day of the week is a field in the layer.

Re: Pulling Attribute Data

Anonymous User — Tue, 22 Mar 2022 18:44:41 GMT

Oh, when you are iterating over the features, I think you can use this expression to get a specific attribute:

item()['attributes']['someField']

For dates, you'd want to format it:

addSeconds('1970-1-1',Div(item()['attributes']?['date'] ,1000),'yyyy-MM-dd')

I haven't tested it but I think these should work.

Re: Pulling Attribute Data

NickCressman — Tue, 22 Mar 2022 18:47:15 GMT

Okay thank you I will have to test that out and let you know.

Re: Pulling Attribute Data

NickCressman — Tue, 22 Mar 2022 19:34:50 GMT

This did work thanks for the help!

Re: Pulling Attribute Data

Michael_VanHatten — Mon, 11 Apr 2022 19:31:02 GMT

Hi Nick,

I am looking to do the same thing you mention in the thread. Integromat/Make is very easy and the attribute data is easy to choose and move around. Were you able to get Power Automate to the same point? My IT team will not allow me to use Integromat so getting PA to work for a survey would be great.

Thanks

Re: Pulling Attribute Data

NickCressman — Mon, 11 Apr 2022 19:39:38 GMT

Yes I did have you attempted yet?. It took me sometime to figure out but i did. I winded up going with make/integromat because it is easier to integrate filters and you don't have to know the formatting as much as power automate to pull a certain field. All the tips that Aaron Provided helped as well.

Re: Pulling Attribute Data

Michael_VanHatten — Tue, 12 Apr 2022 14:44:36 GMT

I have been trying to work things out with microsoft but am not having a ton of luck. I would love to use integromat/ make, I am familiar with it and the ease of use. Still trying to work with IT to open up integromat so for now I am stuck with automate.

Re: Pulling Attribute Data

NickCressman — Tue, 12 Apr 2022 15:17:06 GMT

Well, any questions I would be glad to help.

Re: Pulling Attribute Data

NickCressman — Tue, 12 Apr 2022 15:20:28 GMT

Here is what my flow looks like I followed a help article as well which is above in this chain.