Dealing with Runtime errors in a Canvas App

[stapes]

My canvas app is showing a run time error from a previous run when I open it to edit.

It is showing an error for this statement:

ClearCollect(outstandingOrders,GoodsInToday.Run(WeekNo, SelectedYear, 2))

In the first place, this should not be flagged as an error. No data is NOT an error. It just means no records were found. This is a normal occurrence.

How can these spurious errors be handled / eliminated.

I do not need our users seeing big red errors for no reason.

[v-yutliu-msft · Accepted solution]

Hi @stapes ，

Do you mean that if your flow returns blank value, the formula will show error?

If so, I suggest you try if statement to avoid this.

Try this formula:

If(!IsBlank(GoodsInToday.Run(WeekNo, SelectedYear, 2))||
   !IsEmpty(GoodsInToday.Run(WeekNo, SelectedYear, 2)),
   ClearCollect(outstandingOrders,GoodsInToday.Run(WeekNo, SelectedYear, 2)
  )

In this way, if the flow returns nothing, the clearcollect action will not perform.

Best regards,

[stapes]

Using this formula:

If(!IsBlank(GoodsInToday.Run(WeekNo, SelectedYear, 2))||
   !IsEmpty(GoodsInToday.Run(WeekNo, SelectedYear, 2)),
   ClearCollect(outstandingOrders,GoodsInToday.Run(WeekNo, SelectedYear, 2)
  )

Doesn't this involve running the flow 3 times?

[Sytze]

Twice. Once for the condition and once for either the True or the False part of the conditional stetement.