Genesys Cloud (formerly PureCloud)

Discussion Thread View
Expand all | Collapse all

Data Table Lookup

  • 1.  Data Table Lookup

    Posted 11 days ago
      |   view attached
    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:
    1. I need to do a count of the amount of words in the Field:  State.LoopCount=Count(MakeList(State.WordCollection)
    2. I need to search for words in the message from Email/Facebook = Contains(Message.Message.Body,GetAt(MakeList(State.DataTableLookup),State.LoopCount),true)
    3. I need to search for 1st word in the list, then 2nd, .........
    4. 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?

    Reginald Sheraton
    Bytes Systems Integration a Division of Altron


    DataTable.pdf   14K 1 version

  • 2.  RE: Data Table Lookup

    Top 25 Contributor
    Posted 11 days ago
    Hi Reginald,

    I think you're getting to the point you should use a custom action and handle this logic outside of Genesys Cloud.

    You could use a lambda function if you don't have another way to handle this.


    Daniel McLeod
    Qsect LLC