Select to view content in your preferred language

Pulling Attribute Data

1309
10
Jump to solution
03-22-2022 08:46 AM
NickCressman
Emerging Contributor

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

 

0 Kudos
1 Solution

Accepted Solutions
by Anonymous User
Not applicable

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.

View solution in original post

0 Kudos
10 Replies
by Anonymous User
Not applicable

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

0 Kudos
NickCressman
Emerging Contributor

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

NickCressman_0-1647973609155.png

 

0 Kudos
by Anonymous User
Not applicable

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.

0 Kudos
NickCressman
Emerging Contributor

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

0 Kudos
NickCressman
Emerging Contributor

This did work thanks for the help!

0 Kudos
Michael_VanHatten
Regular Contributor

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

0 Kudos
NickCressman
Emerging Contributor

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.

0 Kudos
Michael_VanHatten
Regular Contributor

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. 

0 Kudos
NickCressman
Emerging Contributor

Well, any questions I would be glad to help.

0 Kudos