Multiple keyword searches with duplicate rows

[Nesly]

Hi again!

I noticed that I have a problem with my flow.. 

With this flow, I'm trying to create multiple keyword searches. This is the result of a survey, and there are some qualitative questions that I'm trying to categorize based on some keywords.  This is a part of the mapping that I'm creating

This Flow work perfectly.. 

this is the formula that I used 

and This is the results that I got: 

The problem that I have with this flow is that it doesn't search for all the words, but not just for the first word that they find. So if a person replied writing about "professor", "room", and "mentor", I would like that his/her row is duplicated one for each key..

How can I do this? always if it is possible.. 

Thank you!

[OTrieger]

@Nesly You need to use a multi field formula tool

[OTrieger]

What you will need to do is tick all the fields that you would like that the logic will be applied to and then in the formula use instead of the respective fields, select Current Fields (relating to all the fields that you ticked above it) and the formula will check if Current Field is empty then Other.

[OTrieger]

[Nesly]

Hi @otrieger , thank you for your fast reply! I think you are confused between my two questions.. one that I asked yesterday when I asked how to add the option "Other," and this one where I asked "How to create duplicates in rows that Have a different key."

[OTrieger]

@Nesly 
You are right, I misunderstood your question.
One way will be using a Batch Macro, that the Control Parameter will be the Key-words, so the Find and Replace will be done in the Batch Macro which will check each of the different key-words for each question. Only I'm not sure if that will be the best way or most efficient way.