Flow to send email when 10 days is passed from cell

[simonpeattie]

Hey Guys 

Need your help again guys im really stuck 

Goal

after 10 days has passed from the date in the Coolum send an email containing the rows information 

i have a excel file, and a flow my flow is currenilty 

Recurrence Daily

list rows in table

apply to each 

                  condition 

Date Coolum            is equal to               expression greaterOrEquals(addDays(items('Apply_to_each')?['Date'], 10))

if yes then send an email with dynamic data 

please see screen shot below 

p.s i have tried using Filter Query and cant work that out either 

[SudeepGhatakNZ]

I suspect some of your dates are empty.

Perform an empty check before comparison

[simonpeattie]

Hello @SudeepGhatakNZ  i have no empty cells in the Date Coolum any other ideas? im so lost 

[simonpeattie]

the error message i get is 

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'addDays' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#adddays for usage details.'.

[simonpeattie]

o this expersion dosnt fail in teh condition section but it dosnt do what i want either its saying that all the days havnt passed with is wrong 

greaterOrEquals(addDays(if(empty(items('Apply_to_each')?['Date']), utcNow(), convertFromUtc(formatDateTime(items('Apply_to_each')?['Date'], 'yyyy-MM-dd'), 'Pacific Standard Time')), 10), convertFromUtc(utcNow(), 'Pacific Standard Time'))

[SudeepGhatakNZ]

I think this is what is causing the issue. Can you filter out the non-date records first and then apply the condition?