Unanswered

flow is "failing" but my emails are sending

(0) Share

Report

Posted on by annabelh12345

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 FlowZoomed in version InkedFlow picture 2_LI.jpg Flow picture 3.PNG

Any help is appreciated.

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
annabelh12345 20 on at

Like (0)

Report

Absolutely, I have uploaded the fail here.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
annabelh12345 20 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
annabelh12345 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
annabelh12345 20 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

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

coalesce(formatDateTime(<<StartDate>>,'yyyy-MM-dd'),'1900-01-01')

Was this reply helpful? Yes No