cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thegnic
Frequent Visitor

Duplicate & Replicated Emails

Hi,

I have a SharePoint list that our sales dept use to add on sales orders. When a new item is added it alerts our finance dept who then process the order on the finance system (completely separate to SharePoint). The finance dept then flag the item on SharePoint as being completed by them - the item then emails the relevant dept for processing the order (this depends on the dept. selections within the item itself which dept receives the email). This all works perfectly fine.

 

This issue we are seeing is if someone goes into the item and modifies anything within the item it then emails the dept. again to advise that there is a new item for processing (sending the same email it did previously when flagged by the finance dept.). Is there any way to prevent the email from being sent if the item is modified in any way?

 

Thanks

Gary

1 ACCEPTED SOLUTION

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

Hi @thegnic 

 

It seems like you want finance dept. to be notified when a new item is added by sales dept.

And only when finance dept. flag the item as completed, send an email to relevant dept.

 

If I’ve understood your need, please feel free to let me know.

 

I have created a flow to meet your need.

 

First, for a new item added by sales dept., notify the finance dept.

Use the condition as below:

1.20-1.PNG

 

Then, only when finance dept. flag the item as completed, send an email to relevant dept..

You need to add following steps to check specific column change. For more information about the steps below, go to the link: Check for a Change in a SharePoint List Column Val... - Power Platform Community (microsoft.com)).

 

1.20-2.PNG

 

1.20-3.PNG

 

1.20-4.PNG

 

The whole flow is as below:

1.20-5.PNG

 

If you still have problem, please feel free to let me know.

 

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yiwenxie-msft
Microsoft
Microsoft

Hi @thegnic 

 

It seems like you want finance dept. to be notified when a new item is added by sales dept.

And only when finance dept. flag the item as completed, send an email to relevant dept.

 

If I’ve understood your need, please feel free to let me know.

 

I have created a flow to meet your need.

 

First, for a new item added by sales dept., notify the finance dept.

Use the condition as below:

1.20-1.PNG

 

Then, only when finance dept. flag the item as completed, send an email to relevant dept..

You need to add following steps to check specific column change. For more information about the steps below, go to the link: Check for a Change in a SharePoint List Column Val... - Power Platform Community (microsoft.com)).

 

1.20-2.PNG

 

1.20-3.PNG

 

1.20-4.PNG

 

The whole flow is as below:

1.20-5.PNG

 

If you still have problem, please feel free to let me know.

 

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

thegnic
Frequent Visitor

Hi Kira,

Thanks for this, i'll give it a go and let you know how it goes.

Gary

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (40,349)