I'm trying to set fields in a canvas app where I have data in two separate SharePoint Online lists but are tied together with a PK of eTASFID & eNDASFID. I'm using a gallery to set varRecord which captures the eNDASFID and navigates to a separate screen for data input. I've create a collection which does have the data in it bu when I try and set a Text Fields using the varRecord.eNDASFID it returns blank, but if I manually add the number it works just fine. Not sure what I'm dong wrong so any help would be appreciated.
Doesn't work:
LookUp(collectionTASFRecord,eTASFID = varRecord.eNDASFID,eTASFNAICSCode)
Works:
LookUp(collectionTASFRecord,eTASFID = "0064z000028IRsN",eTASFNAICSCode)