Only with certain columns will my if/then statement work

(0) Share

Report

Posted on by MG-28021817-0

I have an excel table of 24 qualifications. I have a flow that I want to email me once a week when someone's qual date is 30 days from expiration. In the excel Table, Names are in column A and then each Qualification has two columns Date Qualified and a QualNameExpDate. This works for the first 4 qualifications I have. Then it skips the next 5 and will work with the tenth one but none of the other ones. I have tried writing individual flows for each qualification but the ones that don't work in the main flow won't work in a standalone flow either. I have converted to range and reconverted to a table to ensure I'm using up to date table.

recurrence,--Set to once a week

initialize a string variable,--- Use this to track the names and qualifications that are due

Initialize and set a variable for today + 30 days, --- This is used in the if statement

Call List Rows Present --Select my file and correct table

,For Each Loop-- To loop through the body of the table

Condition if [QualNameExpDate is less than or equal to today + 30 ],---
TRUE -- Append String Variable Name, Qualification,--False Blank---

Outside the loop Email myself with the String Variable as the body of my text.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi

So you are saying that certain rows which should satisfy the condition - go to false section of condition ?

Can you confirm that ?

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report
I have a flow that I want to email me once a week when someone's qual date is 30 days from expiration.

That's not the right sampling rate? You should check daily?

Was this reply helpful? Yes No

MG-28021817-0

2 on at

Like (0)

Report

It is not the sample rate that is my problem.

In the condition statement if the condition is met then my string variable receives the person's name and which qualification it is that is 30 days from expiration. Under a False condition nothing happens and I get emailed a blank email.

The main problem that I have is this is a quick example

Name	ForkliftExpDate	AerialLiftExpDate	FallProtectionExpDate
Daffy Duck	28Mar2025	1Apr2025	28Feb2025
Bugs Bunny	28Mar2025	1Apr2025	5June2026

I should return an email to myself that says

Daffy Duck -- Forklift

Daffy Duck -- Aerial Lift

Daffy Duck -- Fall Protection

Bugs Bunny -- Forklift

Bugs Bunny --Aerial Lift

What I get in my email:

Daffy Duck --Forklift

Daffy Duck --Fall Protection

Bugs Bunny --Forklift

For whatever reason the AerialLiftExpDate won't read even though I have copied the exact same thing for that condition. I have even gone as far as trying to write an individual flow for just that column of my table and it still won't work. I have used Filter Query to narrow it down to that specific column and it still won't work. This is over the entirety of my 24 qualification tracker.