cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dewittsa
Regular Visitor

Triggering an email notification one time only

I'm trying to trigger an email notification to the person assigned in the "SDC Assigned" field.  In my current flow, it is triggering an email every time any of the fields are modified and the SDC Assigned field is populated.  Is there a way to do a check and see if the field is populated, and if not, send the email?  If it is already populated, I would just ignore sending the message.

 

dewittsa_0-1606171261771.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
krootz
Solution Supplier
Solution Supplier

@dewittsa check this vid, you can check specific columns if they changed when your list is updated.

https://www.youtube.com/watch?v=xvmi21KomK0

 

View solution in original post

6 REPLIES 6
PrasadAthalye
Super User
Super User

@dewittsa - Use trigger condition to check the status...

 

Try something like below... Owner is my people picker name

@empty(triggerBody()?['Owner'])

 

PrasadAthalye_0-1606173209172.png

 

Like and Mark this as answer if it helps you resolve your issue.

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Thanks Prasad, I tried this, but whenever I change any of the other fields, I'm still getting the notifications.  Here is the expression I used where 'SDC Assigned' is my people picker field.

 

@empty(triggerBody()?['SDC_Assigned'])

sudharsan1985
Solution Sage
Solution Sage

Hi @dewittsa 

If the trigger condition isn't working, then add a conditional block inside the flow to check for the 'SDC Assigned'. Also, create one more field to store the status of the email sent. If the condition is true ('SDC Assigned' is filled with value and check the email status field whether it is false) then trigger the email and update the email status field to true. Next time when the flow runs it checks for 'SDC Assigned' field and the email status field, though the 'SDC Assigned' field has a value and email status is already updated to true, so the flow will be terminated without sending any extra emails.

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Thanks, but I"m not able to add fields in the sharepoint list as I'm not the owner.  So storing the status of the email sent is not possible in the sharepoint list.  I tried doing a check in the version history to see if the 'SDC Assigned' field was previously modified, but that didn't seem to work.   Is there a way to create a field inside the flow to check against?  Any other suggestions?

krootz
Solution Supplier
Solution Supplier

@dewittsa check this vid, you can check specific columns if they changed when your list is updated.

https://www.youtube.com/watch?v=xvmi21KomK0

 

View solution in original post

Thanks for the link.  This worked well.  I had to make sure to use the right connector, as I kept getting an Error 400 

 

"status"400,
  "message""sinceInput not specified\r\nclientRequestId: dd017e97-bb9f-48d8-95ce-64b0729aad98\r\nserviceRequestId: dd017e97-bb9f-48d8-95ce-64b0729aad98"
 
 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,586)