Multiple keyword searches with duplicate rows

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!

Workflow

Help

Accepted answers

All comments

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.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335