Best answer

Filters are not working when checking monday.com groups for specific email addresses


Badge

Hi,

We need to divide messages received on Salesmsg (we have all emails there linked to phone numbers) based on which group on the Monday.com board that email address is in, and then notify two different Slack channels.For example, if the email of the person who sent a text in Salesmsg is in the group "Sales contacts", notification must arrive in one Slack channel, but if email is in the group "Product contacts", it should arrive in another channel.

With using filter Monday.com colums, all are getting transformed to text, so it is not just email. There are other symbols too, and that is why "contains" and "exactly matches" filters don't work. What is the best solution here?

icon

Best answer by christina.d 21 September 2022, 02:31

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

18 replies

Userlevel 7
Badge +9

Hey squad! I wanted to pop in and let ya’ll know this bug has officially been closed! 🎉

My friend @nicksimard being the wizard ✨ he is even put together this article on mapping fields to dynamic dropdown fields. Check it out here:

Thanks for your patience on this one! 

Userlevel 7
Badge +9

Unfortunately, it looks like with the newest version of the Monday Zap app that some previously available data points are no longer available. (e.g. Group ID)

 

You’ll likely have to use the Monday GraphQL API to derive the desired data points: https://api.developer.monday.com/docs

App APIs can be used in Zaps with the Webhook app: https://zapier.com/apps/webhook/help

 

If you need help, consider hiring a Zapier Expert: https://zapier.com/experts

Hey there, I wanted to pop in and mention it appears @valeriasem is being impacted by a known bug with the Monday app where Group ID values won’t load when a dynamic value is set for the Board ID. 😔

I went ahead and added them to the impacted user report and we’ll be in touch once a fix is in place! We’ll also be sure to update the topic as well. 🙂

Thanks for your patience while we dug into this one!

Userlevel 7
Badge +14

@valeriasem 

Unfortunately, it looks like with the newest version of the Monday Zap app that some previously available data points are no longer available. (e.g. Group ID)

 

You’ll likely have to use the Monday GraphQL API to derive the desired data points: https://api.developer.monday.com/docs

App APIs can be used in Zaps with the Webhook app: https://zapier.com/apps/webhook/help

 

If you need help, consider hiring a Zapier Expert: https://zapier.com/experts

Badge

@Troy Tessalone thank you, step 3 is successful but we don’t have group option for filter (those options are from step 2)

Those are from step 3:



*assets is not a group name

Userlevel 7
Badge +14

@valeriasem 

Did you successfully test step 2?

If an Item was found in step 2, then the Item ID will be returned to use for mapping to other Zap steps.

Badge

@Troy Tessalone What should be Item ID in the third step then? Those are only “Fulfillment Value” are the only options

 

Userlevel 7
Badge +14

@valeriasem 

In Step 2, you need to map a value from Step 1 to the Email field to search by.

 

Badge

Hi @jesse and @Troy Tessalone 
 

No issue is still there on our side. This set up:

Only “Custom” fields available from the second step are fulfilment data ones:

There is no dynamic Item ID column available. In the second step column to search in is the email:

 

Userlevel 7
Badge +9

Hey @valeriasem! Just wanted to check in here to see if you were able to get things set up with Troy’s last suggestion. Let us know - we want to make sure you’re good to go here!

Userlevel 7
Badge +14

@valeriasem

You can use the Custom option to map dynamic variables between Zap steps.

 

Logic is this…

  1. Trigger
  2. Find Item on Monday Board for given Email
  3. Find Item Column values based on Found Item
  4. Filter based on the Group the Item is in on the Board
  5. Send Slack Channel Message

 

Badge

@Troy Tessalone It won’t work like that because we need to choose the exact item ID from the board, which doesn’t make any sense for us, as we need it to be a dynamic search.
Those are options, and we can’t choose anything from the previous step as that is not normal text-data, that is fulfilment data

We need to divide it depending on which group the email address is in (there is one particular group that we need to divide the most)

Userlevel 7
Badge +14

@valeriasem 

Try this...once you found the desired Monday Item, then add another Monday step to get all of the Item column values

 

Badge

@Troy Tessalone  this is step two set up

Userlevel 7
Badge +14

@valeriasem 

How is your Step 2 configured now?

Badge

@Troy Tessalone thank you! But again, on the second step we have only column fulfilment options and not group IDs to choose from

and it only brings “Tags” column all the time

Userlevel 7
Badge +14

@valeriasem 

The way the Filter condition is currently configured will never evaluate to true, thus the Zap will never pass the Filter step.

The condition is trying to compare a Contact email address value to a Monday Board Group ID value.

 

For Step 2 in the Zap, you probably want to use this Monday action: Get Item by Column Value

You’d use this to search for the Contact’s email address on the Monday Board, which will return the corresponding Monday Board Group for the found Item.

 

Then in the Filter step, you probably want your condition to be like this:

[Group ID] contains “XXX”

 

NOTES:

  1. Group ID would be the dynamic variable value from Step 2
  2. XXX would be the internal name of the group ID
  3. The right side argument should be a static value

 

You can use Paths instead of a Filter step to handle both routes (Groups)

 

Filter help article: https://zapier.com/help/create/customize/filter-and-path-rules-in-zaps

 

Badge

Hi @Troy Tessalone, this is overall set-up:

 

We need to send notifications ONLY sender’s email (or phone number either works for us) is in the particular group on Monday.com board. But filter is not working properly. Here is the error we get:

We tried to put “Is not in” filter too, but it just sends all messages to the Slack channel without sender’s email group check. Is it possible to do thing like this in Zapier at all?

Userlevel 7
Badge +14

Hi @valeriasem 

Good question.

Perhaps you can outline a specific data example for us to have more context about the filtering issue.