You’re offline. This is a read only version of the page.
20
Hello All,
I would like advice as to why my flow is saying it "failed" in the run history, however the flow performs all the actions (i.e., sends three emails).
My flow is a recurrence which looks through a SharePoint list, and when today's date="Start Date", it triggers three emails to send. I have used a compose function to get today's date. I then used a condition function asking the three emails to send when the start date contains the compose function.
Technically, the flow still runs, but I would like my run history to say "Successful" as appose to "Failed". I have attached photos for reference.
Overall Flow
Zoomed in version
Any help is appreciated.
Use something like the following. If StartDate is null it will use 1900-01-01 as the date. Substitute whatever field is StartDate and whatever default date you want to use.
Share
Report
All responses (
Answers (
coalesce(formatDateTime(<<StartDate>>,'yyyy-MM-dd'),'1900-01-01')
Hi, to clarify, currently my expression is:
formatDateTime(utcNow(),'yyyy-MM-dd')
When you say to add coalesce(), what would that change this expression to in order to stop the failed expression when no date is entered?
Thanks.
If the loop is using Start date and the start date on one of the records is null then that loop will fail. You can solve that by placing the start date inside a coalesce() with a default value to be supplied when the start date is null.
Hello,
By going through your last comment, you actually resolved my issue. There was never a failed input. The reason it was saying "failed" is because I didn't have inputs for all the start dates.
I changed it, and got the flow to say "successful".
Thank you for all of your questions. They led me to the right solution.
Each individual loop succeeds or fails on its own. In your screenshot you can see the link I've highlighted called 'Previous failed'. Clicking on that link will take you to the specific previous loop that wasn't successful. If one of the loops fails either the previous failed or next failed links will be clickable. Click on one of those and send the screenshot from the particular loop that failed.
Hi,
All of my runs show a successful loop. The last screenshot I sent you was for a false condition, and below I have posted a true condition. The issue is that my flow seems to be running a successful loop, but says failed in the run history.
I do agree with you that it may be saying failed because the condition evaluation is null. I have also screenshotted my compose function. Please let me know if you have any easy fixes. I do not have a lot of experience with functions, so I would not know what to fix.
Thank you!
Can you click on the Next failed link in the loop and screenshot that? This one shows a successful loop. We need one that errors out. But if you look at the error it is complaining that something in the condition evaluation is null. You may need to add a coalesce() around one of the arguments in your condition to handle null values.
Absolutely, I have uploaded the fail here.
Can you show us a screenshot of one of the failed runs? We need to drill down and find which specific action is failing. The most common reason is that one of your records has a null value.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
