cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Automated emails based on date- flow failure

Hi,

 

I have looked at the other threads regarding this topic and none seem to have quite the same issue. I have successfully got a flow to send an email three days before a deadline contained in a sharepoint list. Although the emails are sent, the flow still 'fails' so I get a failure email and the flow history records it as a fail. Is there a way of fixing the flow to prevent this?

Capture1.PNGCapture2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi @SamGibbs,

 

In the Condition, the dynamic content of Date of Feedback should come from the Apply to each. I have made a test on my side with the similar configuration. It works fine.

 

The code used in the Condition is:

@equals(formatDateTime(items('Apply_to_each')?['Date'], 'yyyy-MM-dd'),formatDateTime(adddays(utcnow(),3),'yyyy-MM-dd'))

 

A screenshot for the flow:

1.PNG

 

Please try again with it on your side.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
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

6 REPLIES 6
Highlighted
Advocate III
Advocate III

HI @SamGibbs

 

Can you Provide the Error Details here so we can explore something on it.

 

Thanks 

Dev_Nikhil

Highlighted

Hi,

 

It says "ActionFailed: An action failed. No dependent actions succeeded."

 

In the details bit (the error details appears to be blank):

 

Start time
Jul 18, 8:19 AM (4 hours ago)
Duration
00:00:13
Status
Failed
Error
Action 'Condition' failed
Error Details
 

 

Highlighted

Hi @SamGibbs

 

It seems that you are having the Problem with the Condition into the Flow.

 

I suggest you to create  aVariable Named Date where you can Modify the Feedback date as per your requirement of 3 days or whatever.

 

and i suggest that rather than changing both variables Date Formate change the Newly created variables date Formate to the Date Format which you having by the system.

 

This Approach will surely work in your Scenario.

 

Thanks 

Dev_Nikhil

Highlighted

Hi @SamGibbs,

 

In the Condition, the dynamic content of Date of Feedback should come from the Apply to each. I have made a test on my side with the similar configuration. It works fine.

 

The code used in the Condition is:

@equals(formatDateTime(items('Apply_to_each')?['Date'], 'yyyy-MM-dd'),formatDateTime(adddays(utcnow(),3),'yyyy-MM-dd'))

 

A screenshot for the flow:

1.PNG

 

Please try again with it on your side.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
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

Highlighted

Hi,

 

Thanks, that is working now. Greatly appreciated!

Highlighted
New Member

Hi

 

I have a table of data that includes birthday dates, all I want the flow to do is send an email on their birthday.  I am quite happy to calculate the date that I actually want it sent but having been through all of the help within the community and tried delays and filter an array.  The best result I have so far is that the flow sends an email for all items (people) in my table.

 

Below is the latest version I have of my flow:Capture.PNG

 

Hope this is enough information and that someone can help.

 

thanks

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,962)