Getting this error: "Cannot use a non-record value in this context:" when using "ClearCollect( AddColumns( GroupBy("

(0) Share

Report

Posted on by TxTechnician

"Cannot use a non-record value in this context:"

ClearCollect(NewCollectionName,AddColumns(GroupBy(OtherCollection,"ID","ID1","ID2","GroupName"),"NewColumn",LookUp(List,ID=ID1,ReturnValue)));

Patch(List,ShowColumns(NewCollectionName,"NewColumn","ID"))

I'm getting the error when I add "NewColumn". And it makes no sense at all.

The collection is all that there is. And the value of "NewColumn" is an integer.

This is one of many columns which are calculated, and cannot be used with the Patch() function.

Any ideas?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

TxTechnician 98 on at

Like
a
(0)

Report
Copy link

Link copied!
I solved this by creating a new collection using the showcolumns():
ClearCollect(NewCollectionName,AddColumns(GroupBy(OtherCollection,"ID","ID1","ID2","GroupName"),"NewColumn",LookUp(List,ID=ID1,ReturnValue))); ClearCollect(NEWNEWCollection,ShowColumns(NewCollectionName,"NewColumn","ID")) Patch(List,NEWNEWCollection)