Power Automate to Send Emails when certain fields are updated

[EdDean]

Hello Everyone,

I am in the process of configuring the Citizen Problem Reporter for our community. I have created several Power Automate flows to email citizens when a request is submitted, updated, or when comments are created. I am running into an issue when I try to configure the flow to send emails when only certain fields in the request feature layer is updated. I have tried several different things with no luck. So I am looking to the community for help.

How would I configure the Power Automate flow to only send emails when certain fields are updated? The flow below works if any field is updated in the feature layer.

[EdDean]

Bump

[TimHolsti]

Bump

[DerekFarr]

I am in the same boat as you, did you happen to find a fix for this issue or a work around?

[EdDean]

Not yet, I am still working on it when I get a chance.

[Krocha]

How do you get it to send to the specific person that made that submission? That is where i get stuck lol. I am trying for it to send to internal users who have ArcGIS account within the organization.

[JustPete]

Hi Krocha, this is quite a simple fix. You will need to use logical functions within the advanced mode in the email "To" box. 

Below is a snapshot of what we have. If you have specific users, then you need to assign an email to either a field which they populate with their name, or if tracking is enabled, use the Editor or Creator field.

if(equals(item()?['Attributes/ProjectManager'], 'AL'), '(insert email here)', if(equals(item()?['Attributes/ProjectManager'], 'IF'), '(insert email here)',

[rbd]

@EdDean If the citizen request is submitted via Survey123, there is a way to do this easily if the answer to a submittal question is a certain value. Otherwise... I'm in the same situation as you are, looking to send updates/alerts via Outlook email or Teams when values of certain attributes in AGOL hosted feature layers change.

[LaurelJHill]

Subscribing! 

[Caitlin_Todd_LCOR]

If you find a solution to this please let me know! I'm also trying to do this with a hosted feature layer in AGOL for notifying internal staff when certain types of features have been created or updated.