Trying to get a flow to send an email if the date in an excel file is todays date.

[beanybone]

Hi I've tried several ways to do this but i constantly get stuck with a false answer. 

I have an excel file logging requests for visitors, i need a flow to generate an email only when the date is today. the flow needs to run once daily in the morning 

Please help 🙂

[Hardesh15]

@beanybone 

Please check you excel date column. By default it is set as string. if you want to convert string into date use following in compose action.

addDays('1899-12-30',int(outputs('Compose')),'dd-MM-yyyy')

please make sure that you date format should be same.

Thanks

Hardesh

[beanybone]

thanks, where do i add this? 

at the moment i have the occurrence, followed by [excel]get list rows present, followed by condition which is running a value look up of the date column (which is input as part of a form) against utcNow() function

[Hardesh15]

@beanybone 

Inside Apply to each loop. i user SharePoint list Value. you can use excel values.

Thanks

Hardesh

[beanybone]

You've lost me Hardesh 🤔 sorry i'm not getting it at all this is what i have 

[efialttes]

Sorry I thought this topic was unanswered

[Hardesh15]

@efialttes  My simple solution is not understand by @beanybone .

I do not think so this could be understood.

Please mention clearly if you have any experience in flow so that we provide you exact simple solution.

Thanks

Hardesh

[beanybone]

See below Hardesh, date of is pulling a date field in excel, Very simple if date in date field is today then email, thats what i'm trying to achieve. Thank you so much

[beanybone]

Hi @efialttes grateful for the help! 

At the moment i have a form populating an excel spreadsheet. On that spreadsheet i have a date field currently pulling a date in mm/dd/yyyy format. 

I'm trying to automate a flow to run daily that looks at that date column and if it's todays date, i need it to send an email reminder out. 

@Hardesh15 has given me some wording but i'm unsure where to insert it into the flow. See below the very basic start of where i'm at. Any help much appreciated,  

[Hardesh15]

@beanybone 

No worries. Let me tell you what is happening here.

Date from excel comes in number format like 40213 but utcnow () give you exact date like 2020-09-29T14:20:00Z. That is why your condition output coming as false and going in No block.

The formula which i gave you  is used for to convert excel date number into date.

Thanks

Hardesh

[Hardesh15]

@beanybone 

Go back to my screen shot which i gave you. You have to replace exactly in same way in your apply to each. Expression you saw in compose action i put into comment section for your visibility so that you can understand what i am using in compose input.

What you need to replace 

I used created you need to use your excel date column in compose.

In value you are already supply excel values so no need to change anything in apply to each values.

Thanks

Hardesh

[beanybone]

@Hardesh15  this is what i have now but it's still running with expressionresult; false even though the table contains a line with today's date

[Hardesh15]

@beanybone 

See in compose 2 you put expression in compose input which is wrong. Put your cursor in input box then dynamic panel pop up in that you will see expression tab. Pls paste that expression in that tab box and click ok.

Thanks

Hardesh

[beanybone]

@Hardesh15 still not luck. I've changed as you suggested but still false response. As you can see from the test the output is showing correctly as todays date? I even tried making changes to the utcnow() to show formatDateTime(utcNow(),'dd-MM-yyyy') but doesn't solve it either. 

[Hardesh15]

@beanybone 

Please use one more compose action after compose2 for this formatDateTime(utcNow(),'dd-MM-yyyy') and then see output of that compose. Use contains instead of equal to in condition.

Thanks

Hardesh

[beanybone]

@Hardesh15 no afraid not, no change still false

[Hardesh15 · Accepted solution]

@beanybone 

In condition, change left side with output of compose 3 .

i want to know what you are using in right side of condition.

Thanks

Hardesh

[beanybone · Accepted solution]

@Hardesh15  Success!!!!! 🎉 you're a legend thank you so much for your help! 

[Hardesh15]

@beanybone 

Please accept this as solution if it solves your problem. Do not accept your success comment as solution.

Thanks

Hardesh