Power Platform Community Forum Thread Details

Hello!

As the title says I'm trying to patch data to a SharePoint column. When patching the error "specified column does not exists:"IDcopy" " keeps appearing.

The Patch function:

If(
JOB_LIST_GALLERY.Selected.JOB_DATUM_FINISHED = Blank();
Patch(
JOBIO_DATA;
JOB_LIST_GALLERY.Selected;
{
JOB_DATUM_FINISHED: CurrentTime;
JOB_STATUS: {Value: "Finished"}
}
);
Set(PopupEdit;false)
);;
Set(PopupEdit;false)

The AddColumns() function can be found here:

Sort(
Sort(
Search(
AddColumns(
Filter(
JOBIO_DATA;
IsBlank(Location_Cbox.SelectedItems.Value) || IsEmpty(Location_Cbox.SelectedItems.Value) || JOB_LOCATION.Value = Location_Cbox.Selected.Value;
IsBlank(Function_Cbox.SelectedItems.Value) || IsEmpty(Function_Cbox.SelectedItems.Value) || JOB_WHO.Value = Function_Cbox.Selected.Value;
IsBlank(Priority_Cbox.SelectedItems.Value) || IsEmpty(Priority_Cbox.SelectedItems.Value) || JOB_PRIORITY.Value = Priority_Cbox.Selected.Value;
IsBlank(Status_Cbox.SelectedItems.Value) || IsEmpty(Status_Cbox.SelectedItems.Value) || JOB_STATUS.Value = Status_Cbox.Selected.Value;
IsBlank(Parts_Cbox.SelectedItems.Value) || IsEmpty(Parts_Cbox.SelectedItems.Value) || JOB_PARTS_PRESENT.Value = Parts_Cbox.Selected.Value
);
"IDcopy";
Text('Id (ID)')
);
Search_Txtinput.Text;
"JOB_DESCRIPTION";
"IDcopy"
);
JOB_PRIORITY.Value;
SortOrder.Ascending
);
JOB_STATUS.Value;
SortOrder.Descending
)

Can anyone give information on how to correctly setup the patch function so it works as intended?

Kind regards,

Seba Poncelet

Categories:

Building Power Apps

Hi @PonceletSeba ,

That is because your gallery contains a column which is not in the data source - just do this

If(
 JOB_LIST_GALLERY.Selected.JOB_DATUM_FINISHED = Blank();
 Patch(
 JOBIO_DATA;
 {ID: JOB_LIST_GALLERY.Selected.ID};
 {
 JOB_DATUM_FINISHED: CurrentTime;
 JOB_STATUS: {Value: "Finished"}
 }
 )
);

You can also tidy up the Items a bit

Sort(
 Search(
 AddColumns(
 Filter(
 JOBIO_DATA;
 (
 Len(Location_Cbox.Selected.Value) = 0 || 
 JOB_LOCATION.Value = Location_Cbox.Selected.Value
 ) &&
 (
 Len(Function_Cbox.Selected.Value) = 0 || 
 JOB_WHO.Value = Function_Cbox.Selected.Value
 ) &&
 (
 Len(Priority_Cbox.SelectedItems.Value) = 0 || 
 JOB_PRIORITY.Value = Priority_Cbox.Selected.Value
 ) &&
 (
 Len(Status_Cbox.Selected.Value) = 0 || 
 JOB_STATUS.Value = Status_Cbox.Selected.Value
 ) &&
 (
 Len(Parts_Cbox.Selected.Value) || 
 JOB_PARTS_PRESENT.Value = Parts_Cbox.Selected.Value
 )
 );
 "IDcopy";
 Text('Id (ID)');
		 "JobPriority";
		 JOB_PRIORITY.Value;
		 "JobStatus",
		 JOB_STATUS.Value
 );
 Search_Txtinput.Text;
 "JOB_DESCRIPTION";
 "IDcopy"
 );
 JobPriority;
 SortOrder.Ascending;
 JobStatus;
 SortOrder.Descending
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps