cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmoffatt
Helper III
Helper III

An action failed. No dependent actions succeeded.

Hi,

 

I'm trying to build an automated Email that uses multiple SharePoint Fields. As I try and populate the Email, it continuous to add "Apply to each" to my action as dynamic fields are added, resulting in the picture below.

Email Template.PNG

Then when I run a test, I get back the "An action failed. No dependent actions succeeded." error.

1 ACCEPTED SOLUTION

Accepted Solutions
Spamrancher
Advocate II
Advocate II

@nmoffatt 

 

When I have something where I run into "Apply to Each", but I'm only working with one record; for example CDS-->List Records-->Top Count = 1, I initialize a variable, then set the variable within the "Apply to Each". I repeat that for each field I use, and then at the end I use my variables rather than the dynamic values. It's a little more time consuming to set up, but when I'm troubleshooting I do not have to dive into the nested "Apply to Each" like you're doing.

 

Erik

View solution in original post

8 REPLIES 8
ChristianAbata
Super User
Super User

hi @nmoffatt  normally apply to each is generated when you try to use a propertie that could be an array, so is not necessary to add all the properties inside as you have in the apply to each 2, ju stoy need to pass the content of values



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata 

 

Thank you for the response. I think I'm following you. I need to extract each line from the array as its own value, correct? How would I go about that?

Spamrancher
Advocate II
Advocate II

@nmoffatt 

 

When I have something where I run into "Apply to Each", but I'm only working with one record; for example CDS-->List Records-->Top Count = 1, I initialize a variable, then set the variable within the "Apply to Each". I repeat that for each field I use, and then at the end I use my variables rather than the dynamic values. It's a little more time consuming to set up, but when I'm troubleshooting I do not have to dive into the nested "Apply to Each" like you're doing.

 

Erik

View solution in original post

@nmoffatt , What I suggest you is delete all of your apply to each actions, and add Get ITEMS instead Get ITEM just create an outlook action, so then if you need to read just the email column, click on To field from Outlookn and in Dynamic content just select the column name that correspond to an email. This is going to create you an apply to each that can allow you to read every value in your array one by one



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata 

 

I'm looking for specific fields in a row, not through the column. That's why I'm not using GET ITEMS

@Spamrancher 

 

Thank you for the reply. I'm running into a problem when I try "Initialize Variable" on columns that are "Person or Groups". It creates a " Apply to each" nest and won't allow me to save. Have you had experience with these column types?

@nmoffatt You have to use "Initialize Variable" action first and probably leave the default value blank. Then you can use the "Set Variable" action in your Apply to Each. One thing I didn't ask - are all of these fields data fields, or are any of them lookup fields? If so, then that will add some additional work. It sounds like your "Person or Groups" field might be a lookup field. And as I was searching for how to do that I found the link below, it might be helpful.

 

https://powerusers.microsoft.com/t5/Building-Flows/get-properties-of-Person-or-Group-field-into-vari...

@Spamrancher 

 

I ended up using "Append to string variable" on the lookup field, worked like a charm. Thanks for steering me in the right direction!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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 (910)