I have two lists, for this explanation I will call them List1 and List2, in which List1 has a record and List2 has items related to the record. I created a column in List2, SPID, which is a Number column which stores the ID of the record from List1.
I am trying to display the list of items, in List2, in a gallery. The Items property has the formula,
Filter(eas_SPARChecklistTotals, SPAR_ID = gblCurrentRecord.ID)
However, no information is being displayed. I however tried changing the item formula to,
Filter(eas_SPARChecklistTotals, Value(SPAR_ID) = gblCurrentRecord.ID)
which displays the data but I am now getting a delegation error due to the Value() function. Would like to determine if I should be able to Filter a SharePoint list by comparing a Number column to an ID column.