I'm creating a collection where I'm adding the columns from the other table
The collecttion also have additional columns from the caseprio table and columns being added using add columns
ClearCollect(ColAll, AddColumns(CasePrioritizations, "ProjectID", ( LookUp(colQuestions, 'ADO ID'= lblADOWI.Text ,ProjectID)),"Project Name", ( LookUp(colQuestions,ADOID = lblADOWI.Text , 'Project Name')) , "Project_Manager", ( LookUp(colQuestions,ADOID = lblADOWI.Text , Project_Manager)),"ADOID" , (LookUp(colQuestions,ADOID = lblADOWI.Text , ADOID)),"OTD", ( LookUp(colQuestions,ADOID = lblADOWI.Text , OTD)),"nOTD", ( LookUp(colQuestions,ADOID = lblADOWI.Text , nOTD)),"LD", ( LookUp(colQuestions,ADOID = lblADOWI.Text , LD)),"nLD", ( LookUp(colQuestions,ADOID = lblADOWI.Text , nLD)),"CSAT", ( LookUp(colQuestions,ADOID = lblADOWI.Text , CSAT)),"nCSAT", ( LookUp(colQuestions,ADOID = lblADOWI.Text , nCSAT)),"Production", ( LookUp(colQuestions,ADOID = lblADOWI.Text , Production)) ,"nProduction", ( LookUp(colQuestions,ADOID = lblADOWI.Text , nProduction)),"InvoiceDelay", ( LookUp(colQuestions,ADOID = lblADOWI.Text , InvoiceDelay)),"nInvoiceDelay", ( LookUp(colQuestions,ADOID = lblADOWI.Text , nInvoiceDelay)),"Warranty", ( LookUp(colQuestions,ADOID = lblADOWI.Text , Warranty)),"PMO_Priority", ( LookUp(colQuestions,ADOID = lblADOWI.Text , PMO_Priority)) ,"nWarranty", ( LookUp(colQuestions,ADOID = lblADOWI.Text , nWarranty)) , "Comments", ( LookUp(colQuestions,ADOID = lblADOWI.Text , Comments)),"Project" ,(LookUp(colQuestions,ADOID = lblADOWI.Text,Project)),"nProject" ,(LookUp(colQuestions,ADOID = lblADOWI.Text,nProject)),"Customer Name",(LookUp(colQuestions,ADOID = lblADOWI.Text, 'Customer Name')), "AutoRank",(LookUp(colQuestions,ADOID = lblADOWI.Text, AutoRank)),"PMOAdjustment",(LookUp(colQuestions,ADOID = lblADOWI.Text , PMOAdjustment)),"Locked",(LookUp(colQuestions,ADOID = lblADOWI.Text , Locked)) , "IsUpdated","No"));
Now on select of my gallery I have written the below formula
Patch(ColAll,ThisItem, {'ADO ID': lblADOWI_1.Text, ProjectID:lblPrjID_1.Text, 'Project Name':lblProject_1.Text, Project_Manager:lblPM_1.Text, nProduction: If(
drpProd_4.SelectedText.Value = "Yes",
varProd,
0
),Project: drpPrj_4.SelectedText.Value,
Production: drpProd_4.SelectedText.Value,
nProject:If(
drpPrj_4.SelectedText.Value = "Yes",
varProj,
0
),
nOTD: If(
otd_1.Selected.Value = "Yes",
varOTD,
0
),
OTD: otd_1.Selected.Value,
nLD: If(
LD_1.Selected.Value = "Yes",
varLD,
0
),
LD: LD_1.Selected.Value,
nInvoiceDelay: If(
Invoicedelay_1.Selected.Value = "Yes",
varID,
0
),
InvoiceDelay: Invoicedelay_1.Selected.Value,
nWarranty: If(
Warranty_1.Selected.Value = "Yes",
varWarr,
0
),
Warranty: Warranty_1.Selected.Value,
nCSAT: If(
csat_1.Selected.Value = "Critical",
varCritical,
If(
csat_1.Selected.Value = "Important",
varImportant,
0
)
),
CSAT: csat_1.SelectedText.Value,
PMOAdjustment: Value(txtPMOAdj_3.Text),
AutoRank: Value(calAdjRank_3.Text),
Locked: Locked_1.Selected.Value , Comments:txtComments_1.Text, PMO_Priority:Value(txtPMOPriority_1.Text)});
Now on click of a button I'm writing the below formula:
Patch('2872CaseQuestionnaires',ColAll );
This shows the error Cannot Use Non-record value in the context How to fix this issue ???