Hi all,
I'm building a flow which has a condition reliant on a date from excel. Snip is attached. When using the date formula in other flows it worked perfectly. But in the condition, all of the inputs come out as false. I have checked in other flows and my date is coming out of excel as the correct number, and the formula is producing the same number, so unsure as to what is going wrong. All help is appreciated, thanks a million.
Solved! Go to Solution.
Hi!
Then the issue is probably a data mismatch. So your addDays() expression output is of type integer, but the Excel column is of type string. Try to cast your excel column, by means of int()... or cast your addDays() output by means of string()
Hope this helps
Proud to be a Flownaut!
Hi!
My suggestion is to add a dummy Compose action block inside your 'Apply to each', just before the 'Condition' action block, and assign as its input 'Start date' dynamic content from excel. Now you can inspect easily its content.
My guessing is that your 'Start Date' Excel column has Date format, if so, it is stored internally as an integer. If this is the case, you will find the way to proceed here:
https://www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate
If not the case, please share 'Start date' content and the WDL expression also
Hope this helps
Proud to be a Flownaut!
Hi @efialttes
I appreciate your help with this.
As you can see below, the date matches the output of the formula.
But when I put them into a condition it comes back as failed.
Can you think of any reason as to why this is happening?
Hi!
Then the issue is probably a data mismatch. So your addDays() expression output is of type integer, but the Excel column is of type string. Try to cast your excel column, by means of int()... or cast your addDays() output by means of string()
Hope this helps
Proud to be a Flownaut!
Hi @efialttes
Thank you for your help and I appreciate the suggestion.
I have used the get a row function on several different flows using the same data and formula.
It has worked fine for me in these flows.
However, I need to use list rows present for this flow.
Would using the list rows present function have changed anything?
If not could you write the expression for me to fix this error
Finally solved, right? If so...
Congrats!
Proud to be a Flownaut!
Yes, thanks so much😁
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.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
21 |
User | Count |
---|---|
62 | |
44 | |
40 | |
29 | |
27 |