Answered

Patch with IF

(0) Share

Report

Posted on by OsmandFernando

Hi,

I have a patch formula where it works well, But I want to do a modification with IF.

I have a field name Cash. If the Cash field is blank/empty I do not want to patch. otherwise that means if the cash field has a value do the patch. How can I do that, following is the patch formula,

Patch(
'Cash Received',
Defaults('Cash Received'),
{
Date: DataCardValue180_2.SelectedDate,
'Customer Name': DataCardValue181_2.Selected,
Amount: Value(DataCardValue182_2.Text),
InvoiceNumber: DataCardValue179_2.Text
}
)

Cash field is DataCardValue182_2

Thank you in advance,

Osmand

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Try
If(!IsBlank(DataCardValue182_2),
Patch(
'Cash Received',
Defaults('Cash Received'),
{
Date: DataCardValue180_2.SelectedDate,
'Customer Name': DataCardValue181_2.Selected,
Amount: Value(DataCardValue182_2.Text),
InvoiceNumber: DataCardValue179_2.Text}))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
OsmandFernando on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 Thank you so much. It worked.

Osmand
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Please accept as a solution
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.