Answered

Adding succes and error notifications to a ForAll Gallery patch

(0) Share

Report

Posted on by CPGDallas

Hello,

I have a multiscan barcode reader app that patches to a SQL DB. I am trying to add the success and error notifications that are working on the single scan version of the app.

I receive an 'Error. Cannot update' notification in the app but in the app Monitor (as well as on the SQL DB) I have all successes.

 If(
 IsEmpty(
 Errors(
ForAll(
 Gallery1.AllItems,
 Patch(SQLDB, Defaults(SQLDB), 
{SerialNumber: lbl_Scans.Text, 
Status: lbl_default_Status_1.Text, 
Location: dd_Location_2.Selected.Value, 
Model: dd_SelectItem_3.Selected.Value, 
Manufacturer: dd_SelectItem_3.Selected.Manufacturer, 
ScanDate: Now(), 
ScannedBy: User().FullName,
AssignedTo:lbl_IT_Storage_1.Text,
OSName: dd_SelectItem_3.Selected.OSName,
Type: dd_SelectItem_3.Selected.Type})
 )
 )
 ),
 Notify("Update Successful",NotificationType.Success; 1);Set(SuccessNotify,true),
 Notify("Error. Cannot update.",NotificationType.Error);Set(ErrorNotify, true)
)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CPGDallas ,

Is this what you are trying to do?

ForAll( Gallery1.AllItems, With( { CurrentRecord: ThisRecord }, IfError( Patch(SQLDB, Defaults(SQLDB), {SerialNumber: lbl_Scans.Text, Status: lbl_default_Status_1.Text, Location: dd_Location_2.Selected.Value, Model: dd_SelectItem_3.Selected.Value, Manufacturer: dd_SelectItem_3.Selected.Manufacturer, ScanDate: Now(), ScannedBy: User().FullName, AssignedTo:lbl_IT_Storage_1.Text, OSName: dd_SelectItem_3.Selected.OSName, Type: dd_SelectItem_3.Selected.Type} ), Notify("Error. Cannot update Record - "&CurrentRecord.Name, NotificationType.Error, 1000); false; , Notify("Update Successful",NotificationType.Success, 500); true; ) ) )

Just make sure, you use CurrentRecord like CurrentRecord[@ColumnName] is you have fields in them. else its fine
Hope this helps
CPGDallas 97 on at

Like
a
(1)

Report
Copy link

Link copied!
That did it. Here's my final code:
ForAll( Gallery1.AllItems, With( { SerialNumber: ThisRecord }, IfError( Patch(SQLDB, Defaults(SQLDB), {SerialNumber: lbl_Scans.Text, Status: lbl_default_Status_1.Text, Location: dd_Location_2.Selected.Value, Model: dd_SelectItem_3.Selected.Value, Manufacturer: dd_SelectItem_3.Selected.Manufacturer, ScanDate: Now(), ScannedBy: User().FullName, AssignedTo:lbl_IT_Storage_1.Text, OSName: dd_SelectItem_3.Selected.OSName, Type: dd_SelectItem_3.Selected.Type} ), Notify("Error. Cannot update Record - ", NotificationType.Error, 1000); false; , Notify("Update Successful",NotificationType.Success, 500); true; ) ) )
My single scan submit played a sound upon success and another sound on error. I tried bringing that over but the error message was that it couldn't be done on a 'ForAll'. Which makes sense. Twenty scans playing the sound fx twenty times. I'll take this!