Unanswered

New record being created rather than existing one patched?

(0) Share

Report

Posted on by jed76

Is there any reason why this is creating a new record. Title does exist in the table and the value matches too?

Patch(CB_Job_Tracker,
LookUp(CB_Job_Tracker, Title=JobGantt.Selected.ProjectId,
{
'UM Planning': ComboBox6.Selected.DisplayName,
Date_of_Job: JobStartDatePicker.SelectedDate,
Description: DataCardValue23.Text
}
));

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

FishinKmac 75 on at

Like
a
(0)

Report
Copy link

Link copied!
Can you see if one of these will work?
Patch(CB_Job_Tracker, LookUp(CB_Job_Tracker, Title=JobGantt.Selected.ProjectId), { 'UM Planning': ComboBox6.Selected.DisplayName, Date_of_Job: JobStartDatePicker.SelectedDate, Description: DataCardValue23.Text } );
or
Patch(CB_Job_Tracker, LookUp(CB_Job_Tracker, Title=Text(JobGantt.Selected.ProjectId)), { 'UM Planning': ComboBox6.Selected.DisplayName, Date_of_Job: JobStartDatePicker.SelectedDate, Description: DataCardValue23.Text } );
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks but neither of those work either. I have even tried just replacing the "JobGantt...." with the actual text value.
jed76 on at

Like
a
(1)

Report
Copy link

Link copied!

@FishinKmac Hi. I sorted this by using UPDATEIF instead of PATCH!

Many thanks,
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jed76 ,

There might be a possibility that your filter contains more records to select 1 record to patch. UpdateIf works to make changes to all the records for which your condition is satisfied.

Hope this helps