Filter does not display items in gallery, when comparing a Number and ID column.

(0) Share

Report

Posted on by rpersad

776

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.

Categories:

Business Process Flows

I have the same question (0)