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.
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
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
Inside Apply to each loop. i user SharePoint list Value. you can use excel values.
Thanks
Hardesh
You've lost me Hardesh 🤔 sorry i'm not getting it at all this is what i have
Sorry I thought this topic was unanswered
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
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.
Thanks
Hardesh
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
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.
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
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
Please accept this as solution if it solves your problem. Do not accept your success comment as solution.
Thanks
Hardesh
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
4 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
14 | |
11 | |
6 | |
6 | |
6 |