cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beanybone
Helper I
Helper I

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

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 🙂

2 ACCEPTED SOLUTIONS

Accepted Solutions

@beanybone 

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

Hardesh15_0-1601547171225.png

 

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

 

Thanks

Hardesh

 

View solution in original post

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

View solution in original post

18 REPLIES 18
Hardesh15
Super User
Super User

@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

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

 

@beanybone 

 

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

Hardesh15_0-1601480236231.png

 

Thanks

Hardesh

 

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

beanybone_0-1601481034127.png

 

efialttes
Super User
Super User

Sorry I thought this topic was unanswered



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



 

@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

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

Floe screen.jpg

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, Floe screen.jpg 

@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

 

 

@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

@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

Floe screen2.jpg

@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

@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. 

 

Floe screen3.jpgFloe screen4.jpg

@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

@Hardesh15 no afraid not, no change still falseFloe screen7.jpgFloe screen6.jpgFloe screen5.jpg

@beanybone 

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

Hardesh15_0-1601547171225.png

 

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

 

Thanks

Hardesh

 

View solution in original post

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

View solution in original post

@beanybone 

 

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

 

Thanks

Hardesh

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,451)