i am new to this forum and i am stucked for a while now with a problem - so i would appreciate if someone could help me out.
I am using the "Query List" action for a multiple filter action (3 filters in total) on a "rule table" - the filters with the 2 numbers work as expected but the third filter option is a lookup column where i compare two lookup-fields with each other.
I want to filter by the lookup-Number of my actual table ("lookupNumberA") applied on the rule table which also has a lookupNumber (lets call it "ruleTable:lookupNumber")
It is like this
query list "ruleTable"
where "ruleTable:lookupNumber" is equal to "lookupNumberB"
I always receive an empty result eventhough the numbers are the same. I guess i have to parse it somehow and already tried already fn-Trim, but i just continuing getting empty results.
Does anyone have an idea?
Thanks a lot and best regards