Filtering Dataverse table based on delimited values & other strings at once
I need to filter a dataverse table columns based on value from two Input Text Boxes TextInput1_4 & TextInput1_6 & add to Collection. Each of those boxes can contain more than one search parameter separated by commas. For Ex: DGT98765,TYHR00087,KLIU98752.
I have seen similar solution here Comma Separated Value Used in FIlter but it only has one Input control in my case I have two. Here's the current code but it can Filter only one Search Parameter. Kindly advice how to approach this.
TextInput1_4.Text in Account_Id__c ||
TextInput1_6.Text in 'Name.1' ||
TextInput1_6.Text in 'Name.2' ||
TextInput1_6.Text in 'Name.3' ||
TextInput1_6.Text in Name
Thanks Charlie for the response. Although I already used similar method as below. It's working but as its a matter of searching millions of rows I want to be sure that this is not missing out on any record. For Ex: your code is doing <collection name> in <DV Column Name> while my code is doing this <DV Column Name> in<collection name> does it work both ways?
Account_Id__c in said ||
'Name.1' in wcsrch ||
'Name.2' in wcsrch ||
'Name.3' in wcsrch ||
Name in wcsrch