Gooday/eve to you all:
At wits end because I've spent last two weeks struggling--watched every YouTube vid; Google/Bing/GPT search unfruitful. Help please?
Here's the problem:
The first filter **(cra31_adressecourriel ne null)** on its own works and retrieves 4000+ records from the table.
The other filters produce 0 records and should produce a few hundred records.
I created variables in this attempt:
Can you suggest or point the way for this "citizen developer" please?
Thanks for help.
Chris
That will be like this
cra31_adressecourriel ne null and (contains(cra31_lastname, '@{triggerBody()['Listrows_Filterrows_3']}') or cra31_lastname eq null)
You can write filter conditions easily with FetchXmlBuilder tool.
Here is what I've tried unsuccessfully:
Thank you. You are correct, that was my mistake.
I meant to explain that when the "contains(cra31_lastname, '@{triggerBody()['Listrows_Filterrows_3']}')" is empty it returns 0 records rather than the 4000+ it should return. (By the way, the last name field is blank because these are essentially new records.)
Any idea how to handle this situation, when the contains(cra31_lastname, '<vLastName>') is empty or blank?
Thank you again.
Chris
After simplifying the filter query, you might have updated the filter operator of the 2nd line. The operator in this screenshot becomes "eq" while it was "contains" in the original screenshot. (maybe that's why it returns 0 records instead of 7+ because there is no record with exact match for the lastname = "ch")
Can you update that part back to
contains(cra31_lastname, '«vLastN»')
In trying to trouble shoot the problem, I simplified the filter query as followed with the same results. Here is the filter:
The 1st line on its own produces 4000+ records. Adding the 2nd line, erroneously produces 0 records; there should be at least 7 records.
The column type of both fields is text.
I hope this provides enough info to discover what I'm doing wrong.
What is the data type of the cra31_rgionadministrative column?
Can you please show the filter from one of the flow runs (as in the screenshot below) to see the complete filter with the variables from the input parameter?