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 🙂
Solved! Go to Solution.
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.
please make sure that you date format should be same.
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
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
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,
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.
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.
@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
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.
@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.
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.
Please accept this as solution if it solves your problem. Do not accept your success comment as solution.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
If you are a small business ISV/Reseller, share your thoughts with our research team.