You’re offline. This is a read only version of the page.
Announcements
521
Hi
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
Share
ReportIf(
!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
Hi @PowerApps11 ,
If I understood correctly you have to split your Ifs, otherwise it will always perform only 1 Patch action:
All responses (
Answers (
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
}
)
)
