Power Platform Community Forum Thread Details

I having trouble on this If condition on my form OnSuccess , all I need is for them to work their on so it doesn't tight each other example if I didn't enter Ticket comments still to perform other If statements regardless here is my formula at moment is not patching others if I don't enter comments, there must be a mistake somewhere don't know where please help

If(
 !IsBlank(txtCommentsTicket.Text),
 Patch(
 'TicketComments',
 Defaults('TicketComments'),
 {
 CommentID:Value( varRecordInspection.ID), 
 Comments: Text(txtCommentsTicket.Text),
 Employee: User().FullName,
 Title: Now(),
 ClCst: txtCstLabel.Selected.Value,
 InvoiceNumber: Text(txtInvoiceNumberTicket.Text)
 }
 ),
//,
If( 
 !IsBlank(PaidTextBoxTkt.Text) Or
 drpTrtkt.Selected.Value = "Closed",
 
 Patch(
 ChargePayment,
 Defaults(ChargePayment),
 {
 PaymentDate: Now(),
 
 
 Amount: Value(txttktAmount.Text),
 Payer: varUser.displayName,
 Title: Text(txtCommentsTicket.Text)
 
 }
 )

 ,



If(
 varItemtkt.DueDate <> dteDueDtetkt.SelectedDate && TiketInfoForm.Mode = FormMode.Edit,

Patch(
 'Tiket Audit Log',
 Defaults('Tiket Audit Log'),
 {
 Title: Now() & " - " & User().FullName ,
 Cst:varItemTiket.Name,
 TktID: varItemtkt.ID,
 ChangedDueDate: dteDueDtetkt.SelectedDate
 
 
 
 }
 ))

Thanks

Categories:

Building Power Apps

Hi @PowerApps11 ,

If I understood correctly you have to split your Ifs, otherwise it will always perform only 1 Patch action:

If(
 !IsBlank(txtCommentsTicket.Text),
 Patch(
 'TicketComments',
 Defaults('TicketComments'),
 {
 CommentID:Value( varRecordInspection.ID), 
 Comments: Text(txtCommentsTicket.Text),
 Employee: User().FullName,
 Title: Now(),
 ClCst: txtCstLabel.Selected.Value,
 InvoiceNumber: Text(txtInvoiceNumberTicket.Text)
 }
 )
);
If( 
 !IsBlank(PaidTextBoxTkt.Text) Or
 drpTrtkt.Selected.Value = "Closed",
 
 Patch(
 ChargePayment,
 Defaults(ChargePayment),
 {
 PaymentDate: Now(),
 
 
 Amount: Value(txttktAmount.Text),
 Payer: varUser.displayName,
 Title: Text(txtCommentsTicket.Text)
 
 }
 )
);
If(
 varItemtkt.DueDate <> dteDueDtetkt.SelectedDate && TiketInfoForm.Mode = FormMode.Edit,

Patch(
 'Tiket Audit Log',
 Defaults('Tiket Audit Log'),
 {
 Title: Now() & " - " & User().FullName ,
 Cst:varItemTiket.Name,
 TktID: varItemtkt.ID,
 ChangedDueDate: dteDueDtetkt.SelectedDate
 
 
 
 }
 )
)