Trouble building multiple condition flow

[Englandt]

I'm new to building flows and would like some help.  

I built a flow that reads an excel table and based on TWO conditions, grabs a word doc then sends and email with the document attached.  My struggle is setting up both conditions, without it I can differentiate which attachment to grab.  The conditions are based on the date the flow runs and the text with a specific column within the table.  A snapshot of the flow is below.  Please help.

[RobElliott]

Hi @Englandt what formatDateTime expressions are you using? And what happens when you run the flow, does  the condition always resolve to false?

Rob
Los Gallardos

[Englandt]

The first format date time is 

formatDateTime(addDays('1900-01-01', add(int(items('Apply_to_each')?['DATE TO BE ASSIGNED']), -2)), 'yyyy-MM-dd')

The second is 

formatDateTime(utcNow(), 'yyyy-MM-dd')

Without the second condition the flow runs and is successful when the date within the table is the same date as when the flow runs.  It comes back as true.  all other lines are false.

Tom

[RobElliott]

Hi @Englandt, I recreated the major part of your flow and the only difference was that I put the formatDateTime expressions into Compose controls and used the output of those in the Condition. The first 10 items resolved to false in the condition as you'd expect but the last one resolved to true. So I'm not sure where the error might be in your flow. But perhaps try it using the Compose controls to see if that helps.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[Englandt]

I'm struggling to insert the formatDateTime expressions into Compose controls.  It doesn't give me the option to insert.

Tom

[RobElliott]

Add a Compose control, click in the Inputs field, the Dynamic content box will open. Click on the Expression tab and enter your formatDateTime expression then click OK.

Rob
Los Gallardos

[Englandt]

Sorry about that, I had the screen minimized so I couldn't see the expression box.

Does the email piece go in after the "if yes" section?  What happens with the "if no" section

[RobElliott · Accepted solution]

Yes the email action would go into the green If yes channel. For the items that are ignored because they don't meet the condition then you can just leave the red If no channel empty.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[Englandt]

The email is sent however with the new "date" configuration its sending an email even though the date indicated in the excel table is yesterday.

Also I can't seem to pull a date within a column into my email without it converting to a text format.