Search on multiple columns of an excel file.
Hi guys. I'm struggling with a search input right now. It's supposed to search on four different columns from an excel file (no choice) named "Title" (text) "CODE" (text) "Commission paritaire" (3 digit number or blank) and "Permanent" (Name and surname). On most of the versions of the formulas I have tried, Title and code work fine, Commission paritaire returns either nonsense or nothing and Permanent does not return anything at all. Here's an example of one of my last tries: Filter( 'BASE DE DONNEES PRIMES SYNDICALESs'; IsBlank(SearchBox.Text) || ( Search(Title; SearchBox.Text) || Search(CODE; SearchBox.Text) || Search(Permanent; SearchBox.Text) || Search(Text(Commission_paritaire; "[$-fr-FR]0"); SearchBox.Text) ) ) Can anybody see something wrong with that?