Search keywords in a report

Hi there,
I’m looking for ideas to automate the following process:

We have a report of all expense claims made by our employees, we would like to search for keywords in the comments of these claims. If a keyword is found, then we need the value in the next column to decide what action to take.

This is what the keyword file would look like:

This is what the comments could be:

If no keywords have been found, then the claim is OK and we don’t need to do anything.
If a keyword has been found, then we need to make a queue item for it with the value of ‘Action’. (And a lot of other transactiondata)

I’m having trouble to come to ideas for this. I’m wondering what you guys think.
How to search all the keywords in a comment? Regardless if its with an upper or lowercase for example.

Thanks in advance,
Regards. Guus


I think something like this should do the trick:

Just make all keywords lowercase

1 Like

Thank you @Obsev! It allmost worked; I only needed to change the last assign activity. You used row(“Action”).Tostring and it should be key(“Action”).Tostring.

Just tested it and it works fine!
Thanks for your help.
Regards, Guus

Ah my mistake, but good that it worked :slight_smile:

1 Like