Unanswered

Batch Patch Error Handling: Table Batch with erroneous entries returns only the errors

(1) Share

Report

Posted on by ialbasheir-kbr

Hello,

I am creating a table of records to a sharepoint List in on patch call. This is done using Patch(DataSource, BaseTable , ChangeTable). where BaseTable is Defaults(), The Change Table is made of a ForAll.
I am having this issue.

this patch job successful for those good iterations of the forall but skips the erroneous ones. my problem I tried to capture the return table from forall operation but it only got the errors, I cannot extract the created records from the call itself.

based on documentation: if Error happens in forAll it will return the error but in this case forall is returning a table and it should return a table with created records along error records for each error happened.

I also would like to note that I cannot separate the forall from the patch they have to be chained for the batch job to work, I could not create variable and pass it in between.

Thank you

>>>>>>>>>>>>>>>> more context

Microsoft states in here: https://learn.microsoft.com/en-us/power-platform/power-fx/error-handling if a functions return a table but has errors it will return table of created records along with records who had errors in some of its fields or return the whole record as error: shown below

The issue: FORALL, is only returning errors but not a table of records along erroneous ones.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @ialbasheir-kbr

So its either by design, a bug or a scope issue in the code.

Can you please share your Code

Was this reply helpful? Yes No
ialbasheir-kbr 87 on at

Like (0)

Report
Copy link

Link copied!
Sure here is the what I am doing.. I am basically archiving a list of items into an archive list with extra metadata

UpdateContext({createdArchs: Patch( eLearningArchive, ForAll(selected_eLearning, { List Data } ) )});

There are multiple things I noticed..

1. This code is works as intended when all the list data are ok

2. if the forall() has one bad item in it like divide over zero, the patch won't happen, and the returned table has 1 error record.

3. if the forall() is good, but it passed one bad record within the table to the patch(), it will return a table of created items and I have no data about failed record

4. I cannot split the forall() from the patch() itself. like putting in a var then pass it to patch(). Powrapps thinks I am doing record to record ops and expecting a record while I am actually doing table to table op

Was this reply helpful? Yes No