Regex on Tables Look up data in a column

In my process my email trigger will receive multiple attachments of the same file type (xlsx). I want to use the file names to identify the different files included on the trigger email. The challenge is that each file name will be unique because it includes a timestamp. For example "MyFileNamev20210122093300.xlsx". How can I use Regex to identify the file based on the prefix of the file name (ie like "MyFileName%") from my trigger attachments table?

Best Answer

  • Adam_636382
    Adam_636382 Posts: 32
    Answer ✓

    Solved my own question with a workaround.
    1. Add a column to the Trigger Attachments table
    2. Use Tables Apply Formula to populate values into the newly created column. Use "columns[#].includes('text to search)" to identify substring text.
    3. Finally perform a Tables look up data in a column using the newly created column to filter on the result from the formula applied in step 2.