unable to filter with an equal condition but value are truly equals

[NicoLaPoir]

Hello,

I am blocked in the development of my app and cannot find why. 

I have two SharePoint list, one with a text field "WR Number" and another one with a "Waiver Request Number" field. Those fields are used to map those 2 list together and the value in those fields are the same.

I am trying to do a Gallery to show the item of the second list matching with the one I am seeing in detail, in the "Items" condition of my gallery I have put this formula and it doesn't work:

Filter('Waiver Request Advise',MonItemSelect.'WR Number'= 'Waiver Request Number')

but when I put this one it works:

Filter('Waiver Request Advise',MonItemSelect.'WR Number'in 'Waiver Request Number')

when it works I have add a label in my gallery with this formula :

MonItemSelect.'WR Number'= ThisItem.'Waiver Request Number'

and it is saying "true"...

so I don't understand why my filter is not working with "=". And I need it to work because "In" is not delegable.

Can you help me?

[v-qiaqi-msft]

Hi @NicoLaPoir，

Do you want to filter the 'Waiver Request Advise' based on the 'Waiver Request Number'?

Actually, if you want to filter the records sharing the same 'Waiver Request Number' column value with 'WR Number' in anther list MonItemSelect, I think you could only use the operator "in" because you are comparing two single column tables.

[NicoLaPoir]

Yes but "in" is not delegable, so not working on the entire table that is more than 12000 elements.

[v-qiaqi-msft]

HI @NicoLaPoir,

I mean the in operator is necessary, which means the delegation issue could not be solved in your issue.