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

An action failed. No dependent actions succeeded.

Hello guys, It's my first time using Microsoft Flow and I have sort of hit a dead end.

I am trying to automate sending emails to fellow employees on their birthdays.

 

I scaled the first 2 stages but the test failed in the last 2.

Please what could be the reason and what possible solution can help me.

 

I will appreciate your help. Please find screenshot below.

2019-01-10 11_16_28-Run History _ Microsoft Flow.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

Hi @Signiore,

 

Could you share more details on the Condition? What is the function being used in the function?

According to your description, it seems that you would like to send out an email to employees on their birthdays.

I have made the following test for your reference.

Add a proper trigger. I am using a Button trigger for testing, you could just change it to Recurrence so that it could run daily.

Get items from the list which contains three columns, Title of type text, Birthday of type Date and time, and Employee of type Person and group.

Add action Filter array with the following code to filter out employees that birthdays equal to Today:

@equals(formatDateTime(item()?['Birthday'], 'MM-dd'), utcnow('MM-dd'))

 

Add an Apply to each, select output Body from Filter array. Then send an email to corresponding employees. Input the following code in the To field to get the email address of the employee:

item()?['Employee']?['Email']

 

A screenshot for your reference:

1.PNG2.PNG

 

Best regards,

Mabel

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

1 REPLY 1
v-yamao-msft
Community Support
Community Support

Hi @Signiore,

 

Could you share more details on the Condition? What is the function being used in the function?

According to your description, it seems that you would like to send out an email to employees on their birthdays.

I have made the following test for your reference.

Add a proper trigger. I am using a Button trigger for testing, you could just change it to Recurrence so that it could run daily.

Get items from the list which contains three columns, Title of type text, Birthday of type Date and time, and Employee of type Person and group.

Add action Filter array with the following code to filter out employees that birthdays equal to Today:

@equals(formatDateTime(item()?['Birthday'], 'MM-dd'), utcnow('MM-dd'))

 

Add an Apply to each, select output Body from Filter array. Then send an email to corresponding employees. Input the following code in the To field to get the email address of the employee:

item()?['Employee']?['Email']

 

A screenshot for your reference:

1.PNG2.PNG

 

Best regards,

Mabel

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

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.

Users online (2,390)