Safeguard Deleting Records - Getting Patch Error

(0) Share

Report

Posted on by NitroPepsi

221

Hi,

I have a gallery and at the end of each record I have a little trash can. What I tried to do is make the record inactive instead of it being deleted; however, I am getting an error. This is the patch formula that I used. Patch('[incentive_test].[D_eTime]',ThisItem,{'DELETE_IND':{Value:"Y"}})

The error that I am getting is saying the type of this argument 'Delete_IND does not match the expected type 'Text". Found type Record.

Now for the DELETE_IND value I made the select "N" and "Y" with the DataCardValue13.Selected.Value

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@NitroPepsi

This indicates what is says...the column is expected to be text, not a record.

Please consider changing your Formula to the following:

Patch('[incentive_test].[D_eTime]', {yourPK: ThisItem.yourPK, 'DELETE_IND': "Y" } )

Since you are using SQL, it is not going to have complex column types, so using {Value: "Y"} is a record that it will not understand.

Also, when you patch, provide your Primary Key column. That is ALL that patch needs and it will be more reliable to indicate the exact record to patch.

I hope this is helpful for you.
NitroPepsi 221 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked like a charm!
NitroPepsi 221 on at

Like
a
(0)

Report
Copy link

Link copied!

Another question for you,
Thank you for your responses, Another question for you, I also wanted to update who modified and the time. I tried putting this in but it did not like it. How can I get this to work?

Patch('[incentive_test].[D_eTime]', {ID: ThisItem.ID, 'DELETE_IND': "Y" },
{ID:ThisItem.ID,MODIFY_USER:User().Email},
{ID: ThisItem.ID, MODIFY_TIMESTAMP: Now()}))
NitroPepsi 221 on at

Like
a
(0)

Report
Copy link

Link copied!

Update, does this seem correct?
Patch('[incentive_test].[D_eTime]', {ID: ThisItem.ID, 'DELETE_IND': "Y"}, {ID: ThisItem.ID, MODIFY_USER: User().Email},{ID: ThisItem.ID, MODIFY_TIMESTAMP: Now()})
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@NitroPepsi

No, you would only need to specify the record you want to patch. That is multiple records!

So the formula would be:

Patch('[incentive_test].[D_eTime]', {ID: ThisItem.ID, 'DELETE_IND': "Y", MODIFY_USER: User().Email, MODIFY_TIMESTAMP: Now() } )
NitroPepsi 221 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much! It worked.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@NitroPepsi

No Problem!!