Collections comparison form GSheets import

(Yaroslav Rotar) #1

Hello :slight_smile:

I have a little issue with GSheets import and Filters work:

  1. I have user handle from Telegram after catch-all actions
  2. I have the list of users handles collection from List Row action from GSheets.
  3. I would like to compare actual user handle from my bot user communication with this list to be sure that this my “special” user

I’ve already used collections cheat sheet and commas with the “equals one of the”, etc.
How can I compare Value 1 (user_handle) with Value 2 (list of string user_handles from a GSheet)?
Should I compare every possible case separately or something else?

Thank you for any help in advance :slight_smile:

(Karen Barker) #2

Hi there,

I’d have thought this should work, but give it a try the other way round so the filter reads List of user_handles contains user_handle. You’ll need to use the && option to get a comma formatted list of values. :slight_smile:

(Yaroslav Rotar) #3

Will try :slight_smile: thank you