web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter does not displa...

Power Automate

Unanswered

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

(0) Share

Report

Report

Posted on by rpersad

780

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:

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation