Power Platform Community Forum Thread Details

Hello everyone!

I have an array with some keywords to search for and I want those strings to be searched in an Excel column.As I understand it, I cannot filter the excel by two conditions, so what I have done is make a single filter for the first term of the array and then I have created a "Filter array" flow.

If I add the static filter to this flow it works without problems, the problem is that I cannot add the static filter since I do not know how many elements there can be in the array since it depends on what the user enters.

I had thought about creating a string variable with the conditions for the search but this does not work for me, when it is executed it tells me that it is not a valid boolean.

Does anyone know how I can fix this or if there is a better way to approach this?

Thanks in advance

Categories:

General topics