hi there,
i currently have a situation whereby i have +-20 words which should be searched for in the Body and Subject of a Email/Facebook
to avoid making changes to Flow when new words needs to be added, i am using a Data table to populate the words.
this works fine when i populate each word into a row with separate Fields for each word, with this option, i still need to make changes to Flow when new words are added.
what i am aiming to achieve, is to have 1 x Row with 1 x Field where i can enter all words into one Field to avoid Flow changes, attached.
The issues are have with this option is:
- I need to do a count of the amount of words in the Field: State.LoopCount=Count(MakeList(State.WordCollection)
- I need to search for words in the message from Email/Facebook = Contains(Message.Message.Body,GetAt(MakeList(State.DataTableLookup),State.LoopCount),true)
- I need to search for 1st word in the list, then 2nd, .........
- when the search reaches the last word the Loop must end
Can someone please advise if this is possible and what would be the best way to achieve this?
#Routing(ACD/IVR)------------------------------
Reginald Sheraton
Bytes Systems Integration a Division of Altron
------------------------------