Unanswered

Why is my Patch throwing an error?

(0) Share

Report

Posted on by jan_mac

106

Hello everyone please help. I am trying to put a patch function to the "OnSelect" property of a checkbox, the goal is to update the Status column. The problem is patch is throwing "some invalid arguments" when I click the get help option it says that the specified column "Date" does not exist. I don't understand why this is causing an error "Date" doesn't exist because it is a column created using AddColumns and it is used in a label but not in the patch formula. I tried removing and reconnecting the data sources which is two excel tables but not change.

Patch(Trainees, ThisItem, {Status: "Completed"})

If it's helpful I merged the two excel tables in the gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@jan_mac
are you updating a choice field if yes you need to modify the code like below

Patch(Trainees, ThisItem, Status: {Value: "Completed"} })

For the date the reason you getting is you’ve added a extra field and you data source is not existed, all you have to do use
DropColumns(MenuDataColl,"Item")
Or lookup where you put ThisItem but try the first code I have modified

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jan_mac ,

You could also use Updateif function for updating the data.
UpdateIf(Trainees,ID=ThisItem.ID,{Status: "Completed"})

Was this reply helpful? Yes No
jan_mac 106 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I tried the first code it didn't work as for my data source I tried using a single table only and that eliminated the error in the checkbox so I guess the problem is the added Column "Date" but I don't understand why it would cause an error since it's not the only added columns. As for the dropColumns where am do i put it on the gallery or on the checkbox?

Was this reply helpful? Yes No
jan_mac 106 on at

Like
a
(0)

Report
Copy link

Link copied!

I also tried this it could work, however this code would update all rows. Do you know a way to only update the checkbox that was checked by the user?

Was this reply helpful? Yes No
jan_mac 106 on at

Like
a
(0)

Report
Copy link

Link copied!

I've traced the problem now it is my added columns since patch returns the modified record it cannot return a column or a record that doesn't exist which is why it is throwing an error. That being said is there way to update a table even though there are added columns to it?

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jan_mac,
UpdateIf will update only row if you write the condition which returns only one row. You can try updateif only for selected checkbox also, using updateif you can update min row with min one column value.
If you can share more details on your requirement I'm happy to help.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Put the code Oncheck of the Checkbox

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@jan_mac
Try this please and let me know

Patch(Trainees, LookUp(Trainees,ID = ThisItem.ID), {Status: "Completed"})

Was this reply helpful? Yes No
jan_mac 106 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Thank you for your reply however my table doesn't have an ID column the only unique column is the TrainingID which is used like a foreign key to reference the Training List table.

Trainees Table
Name
TrainingID
Status

TrainingList Table
TrainingID
TrainingName
Date Completion

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Patch(Trainees, LookUp(Trainees,TrainingID = ThisItem.TrainingID), {Status: "Completed"})

Was this reply helpful? Yes No