Select to view content in your preferred language

Power Automate to Send Emails when certain fields are updated

1685
13
02-08-2024 09:04 AM
EdDean
by
Emerging Contributor

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.

PowerAutomateUpdate.PNG

13 Replies
EdDean
by
Emerging Contributor

Bump

0 Kudos
TimHolsti
Emerging Contributor

Bump

0 Kudos
DerekFarr
Occasional Contributor

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

0 Kudos
EdDean
by
Emerging Contributor

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

0 Kudos
Krocha
by
Frequent Contributor

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.

0 Kudos
JustPete
Regular Contributor

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)',
0 Kudos
rbd
by
Occasional Contributor

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

0 Kudos
LaurelJHill
Emerging Contributor

Subscribing! 

 

0 Kudos
Caitlin_Todd_LCOR
Regular Contributor

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. 

0 Kudos