Skip to main content

Notifications

Power Automate - General Discussion
Answered

Creating a Flow to send emails based on excel tables

(0) ShareShare
ReportReport
Posted on by 13

Hi everyone 

 

i really need some help here. 

 

I have a excel workbook which creates the following tables. 

they are being populated by a filter formula and is dynamic. 

It get filled with any date that it either 1 or 2 days before today

so on the 13-06-2024 it would send and email that has the date registered as 15-06-2024 and again om the 14-06-2024

(pure for test the real values will be different.) 

column 1 is storing the first value of the 2 (you can change the days before in the excel sheet) 

Thomas_Andersen_0-1718509050783.png

So the table is only showing row that need to get an email. 

The Dateint i the end is show if it is the first or second version that they need to recieve. 

 

Now i have tried to create a flow that takes in these value, and make a comparison between the dateint in table1 and the Column1 in table2 

 

If the the dateint value matches column1 when it should send email 1 else email 2. 

 

Here is the flow i have created but i creates alot of different behavior. 

Thomas_Andersen_1-1718509456383.png

 

First: list rows present in a table only list the values with dateint as 2 but not the ones with dateint as 1 

 

and i get the following errors in: 

For each: ActionFailed

An action failed. No dependent actions succeeded.
 
Condition: ActionFailed
An action failed. No dependent actions succeeded.
 
for each 1: ActionBranchingConditionNotSatisfied
The execution of template action 'For_each_1' skipped: the branching condition for this action is not satisfied.
 
for each 2: ActionFailed
An action failed. No dependent actions succeeded.
 
send an email v2 :
ActionDependencyFailed
The execution of template action 'Send_an_email_(V2)' is skipped: dependant action 'For_each_1' completed with status 'Failed' and code 'NotSpecified'.
 
Anyone who can help me. This is proberly just a small error somewhere. 
 

 

 

 

 

  • Verified answer
    Thomas_Andersen Profile Picture
    Thomas_Andersen 13 on at
    Re: Creating a Flow to send emails based on excel tables

    I completly rebuild the whole thing and use a different solution which works perfectly. 

  • Anil_g Profile Picture
    Anil_g 668 on at
    Re: Creating a Flow to send emails based on excel tables

    @Thomas_Andersen 

     

    As per error your for each 1 is failed..check why it is failed...what are you doing in it?

     

    open the flow history and check the values and exact error from there

     

    cheers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard