Unanswered

How do i find what record is erroring in a Get All Items

(0) Share

Report

Posted on by Andrew260z1

I have a multi-line condition that seems to be encountering an issue with one of the SharePoint rows it processes but I cannot figure out what it is or what is the reason; It appears to be the date comparison but from what I can see all my SharePoint items contain a valid date and if I export to Excel go to row 92 - the date is indeed there.

I'm trying to see exactly what Power Automate is having a problem with but "line1 - column 2895" is not helping me if i dump out the JSON file to notepad++ ; how can I see what is the actual problem here?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

As I see your Condition action block has 4 condition rules defined. The onewith Column ETD on the left is the one that crashes in iteration 92. So column ETD seems to be empty for one of your SP items.

I would modify your 'ETD' based current condition rule to override this error by means of the coalesce() WDL function. So if 'ETD' column value does not exist, coalesce() will provide a default alternate date. THe point is, what's your expectation in case this happens? Should the 'ETD' condition rule be evaluated as true or false? Since the four contidion rules are related via AND operator, once any of them is evaluated as False, flow will take the false branch.

Hope this helps

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
One more comment

In order to identify the record that is failing, you can add a 'Compose' action block just before the 'Condition' action block, and assign it the whole SP item from current iteration. Just select 'Current item' from dynamic content menu or, assign it the following WDL expression:

item()

Hope this helps

Was this reply helpful? Yes No
Andrew260z1 83 on at

Like (0)

Report
Copy link

Link copied!

For sure I expect that there is an ETD for all records but in some cases there may not be; If you can link to me how to I might be able to use the coalesce() function for providing a default that would help me. Yes if the ETD is < Today - 3 days and the other conditions match take the true branch.

Also thanks for the tip on the compose block - I will see what the item is.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Andrew

Can you share current addDays() WDL expression you use to compare with ETD?

I need it to see which date format you are handling inside ETD column, and share a customized coalesce() example

Plesae also hover your mouse over the ETD column dynamic content (the one you added on the left part of your condition rule) and share the text displayed. The internal column name should be displayed there, I need it to customize the coalesce() example accordingly

THanx!

Was this reply helpful? Yes No