Unanswered

Validating a ForAll Patch Function

(0) Share

Report

Posted on by alJohSe

I have a gallery of with input fields that I patch into the database. Is there a way to validate the patch has been successful or not?

ForAll('Gallery1'.AllItems,
 Patch('Sharepoint List', {
 Title : 'Combobox_1'.Selected.Code,
 'Delivery Note' : 'TextInput_1'.Text,
 }
 );
);

I have tried to make use of Errors function, made a field required in the list, and tried patching an empty data into it, but it returned Patch successful.

ForAll('Gallery1'.AllItems,
 Patch('Sharepoint List', {
 Title : 'Combobox_1'.Selected.Code,
 'Delivery Note' : 'TextInput_1'.Text,
 }
 );
);
If(
 IsEmpty(
 Errors('Sharepoint List')
 ),
 Notify("Patch Successful",NotificationType.Success),
 Notify("There is an error with your Patch function",NotificationType.Error)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (1)

Report
Hi @alJohSe ,

Can you try the following code?

Clear(colErrors); ForAll( 'Gallery1'.AllItems, IfError( Patch( 'Sharepoint List', ThisRecord, { Title : 'Combobox_1'.Selected.Code, 'Delivery Note' : 'TextInput_1'.Text } ), Collect(colErrors, {Title: 'Combobox_1'.Selected.Code, Message: FirstError.Message}); ) ); If( CountRows(colErrors) > 0, Notify("There is an error with your Patch function",NotificationType.Error, 2000), Notify("Patch Successful",NotificationType.Success, 1000) )

Hope this helps

Was this reply helpful? Yes No
alJohSe 9 on at

Like (0)

Report
Hey @Ethan_R , thank you for the reply.

I tried implementing the code you shared, but it runs into an error (invalid argument type table expecting a record value instead)
ForAll(Gallery2.AllItems, IfError( Patch( 'Testing Test', LookUp('Testing Test',id0 = TextInput2.Text), { Title: TextInput1.Text}), Collect(colErrors, { Title:TextInput1.Text, Message:FirstError.Message } ) ); );
However, the code runs fine if I remove the ForAll function.

Was this reply helpful? Yes No