Pulling Attribute Data

[NickCressman]

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-laye...

[Anonymous User]

@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-workflo...

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.

[NickCressman]

@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.

[Anonymous User · Accepted solution]

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.

[NickCressman]

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

[NickCressman]

This did work thanks for the help!

[Michael_VanHatten]

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

[NickCressman]

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.

[Michael_VanHatten]

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. 

[NickCressman]

Well, any questions I would be glad to help.