web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Cannot Use Non-record ...
Power Apps
Unanswered

Cannot Use Non-record value in the context

(0) ShareShare
ReportReport
Posted on by 47

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 ???

SYED_786_0-1693377317718.png

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard