cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andythefirst
Level: Powered On

Email being sent when new List item added

Hi,

 

I have a flow to send an email from a list when a column is ammended.  This works well however when a new row is added on the list from a form which feeds the list my second flow is triggered to send an email even though it shouldnt be as the previuos row hasnt been amended. 

 

Firstly i hope this makes sense an secondly please help 🙂image001-1.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Email being sent when new List item added

Also, I am assuming that you are choosing the "Date Offered Value" in the condition. Please confirm!

View solution in original post

37 REPLIES 37
Dual Super User
Dual Super User

Re: Email being sent when new List item added

Hi @Andythefirst 

 

Can you share more details? As I understand, you have a sharepoint list and a flow is triggered to send an email when an item is upated or created. Am I right? 

 

 

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi,

 

I only want the email to be sent when a specific column in a specific row of data is amended not when a completly new row is added.

 

i have tried changing this now to Yes in the condition and to email if yes but i now get told ActionBranchingConditionNotSatisfied?

 

Thanks

Andy

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Looked into the flow fail more and it is saying the Branching condition was not satisfied

Super User
Super User

Re: Email being sent when new List item added


@Andythefirst wrote:

Looked into the flow fail more and it is saying the Branching condition was not satisfied


You need to put something in the right side of the condition. Without a complete condition (meaning an entry on both sides of the condition), it will never be satisfied.

You'll also likely need to add some further logic to keep it from sending an email on creation. So you can add a second line to your condition and change it to an Or condition or keep it an And condition. Example:OrCondition.PNG

An example of how you can keep it from sending an email on new rows is to add a condition that says "is not equal" to null. You could also add a condition that is time based, so if created time is UTC Now or like UTC Now - 5 Minutes then it wouldn't send an email. Could also query modified time as well to insure that you are only sending on updates. 

The best way to accomplish this secondary logic depends on your dataset and how often it is updated and how many people may be changing it. Of the top of my head I can think of about 10 options for this. Work with what's best for you and your data.  

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi,

 

Thanks for your help so far but I am still struggling.  It's my first time using flows so stil trying to get my head around it all

 

I have added the AND condition for modified by is not eqaul to UTC Now. But how do i make UTC Now - 5 minutes.

 

I expect to have about 10 people using the form and list daily upto maybe 20/30 times a day.

 

Also if i want nothing to happen if there is a no condition to satisfy the condition what do i put in No?

 

Thanks again

Andyimage001-2.png

Dual Super User
Dual Super User

Re: Email being sent when new List item added

For the UTC now - 5 minutes use the expression : 

addMinutes(utcNow(),-5)
 
In the No branch don't add any actions and leave it as is if you do not want any action for that condition as no. 
 
Hope this Helps!
Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi,

 

I'm afraid it is still not sending the email when date offered is changed to yes.

 

checked the flow again and says the problem is with the branching condition for send an email not being satisfied

 

Thanks 

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi,

 

please forgive my newbieness here cos i might be wrong by a million miles.

 

Could this be my problem?

 

When i look at my flow and it says successful when i click get item it says Date Offered Value - Yes and then date offered in code with ID as 0.

 

I thought maybe i need a 1 in id to trigger the email so went tu change the order of choice in my list to No on the first line and yes on the second line.

 

However i am now showing Date Offered Value as No even though it is Yes on the list and my ID is still 0.

 

I have attached some pictures so I hopefully make more sense

 

image001-3.pngimage001-4.png

 

Thanks

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi,

 

so clearly this made no difference so i am at a complete loss. 

 

I just dont understand why the email isn't sending.  I look at the parameters and believe it should be.

Has the Date Offered box in the list been edited to say yes from the dropdown.

Was the row created inside the last 5 mins. - No

Then i think the email should be sent but it says branching not satisfied.

 

Any more help would be greatly appreciated as i dont know what to do now

Thanks

Dual Super User
Dual Super User

Re: Email being sent when new List item added

@Andythefirst can you share a screenshot of the condition from the flow and the screenshot fo the error that you got. 

 

 

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

HI @yashag2255 

 

Please see screenshots below

image001-5.pngimage001-6.png

Dual Super User
Dual Super User

Re: Email being sent when new List item added

Can you Initialise a variable between the get item and condition? In the varaible type any name, select the strig format and in the value put the "Date off.." of your sharepoint column. Run the flow and please share a screenshot of what data is coming inside the variable. 

 

 

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi @yashag2255 ,

 

This is what I am getting now. I think i did it correctly

 

image001-9.png

Dual Super User
Dual Super User

Re: Email being sent when new List item added

Hey @Andythefirst  You are getting "Yes" in teh variable and in the condition you are comparing "yes" please make this change and test it out.

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

sorry, i am being thick as.

 

what change do i need to make? 

Dual Super User
Dual Super User

Re: Email being sent when new List item added

Hey @Andythefirst No Problem!

 

In the condition where you are comparing "Date off..", change "yes" to "Yes" in the first condition 

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi @yashag2255 

 

unfortunatly it's still not worked 😞

Dual Super User
Dual Super User

Re: Email being sent when new List item added

Hey @Andythefirst Can you please post the error screenshot? What response are you getting now? This condition has been rectified. I think we will have to work on the second condition. Can you share detaills on what your second condition is? also in the initialise variable that you did last time to get the variable, can you change the value of the variable now and get the one which you are using in the second condition and share a screenshot of the data you are getting in that?

 

Thanks 

Andythefirst
Level: Powered On

Re: Email being sent when new List item added

Hi,

 

This was what i got last time.

 

image001-10.png

 

The second condition i put in was based on when a new row was added to the list it was triggering the flow and sending an email even when Date offered was still blank or saying No.

 

The idea for this one is if it was created in the last 5 mins dont send the email. But it might not be right as now no emails are being sent at all.

 

image001-11.png

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 163 members 6,139 guests
Please welcome our newest community members: