Filter Emails from Gmail pack

I have the gmail pack and have synced my emails and showed the “From email” column so I can display the email address. In the same document I also have a separate Contacts Table with an email column and other information for each contact.

I would like to filter the synced emails “using” the emails in my Contacts Table. This way I only see emails from contacts and filter the rest.

I’m sure there is a simple formula and I can’t imagine I’m the only one who wants to do this. So I wanted to ask here. The Gmail pack adds a filter to the “From email” as it’s a related column from the pack. Surly there is a way of globally filtering the emails from a column or list. I have added a control (lookup) where I can select the contacts I want, but am not getting this to filter correctly. What could I be missing?

Any Ideas?

Hi @Jonathan_Fritzler,

I had a similar issue. I wanted to link to the Gmail table in my contacts list so that when I went into a contact I could see emails only related to their email address.

The main issue stems from the the fact that the From column related to the Gmail pack will not work as you expect. It contains more than just the email address. There is not a column that returns just the email that you can then work with.

If you run “ToText” on the From column it returns what is contained behind the front facing text.

E.g. It shows: image

ToText(thisRow.[Email Subject].From)


{"Name":"Google Play","Email":""}

I created a separate column (it can be hidden), called it From Address (regex) and used this as the formula:

regexExtract(ToText(thisRow.[Email Subject].From),'(?<=Email\"\:\")(.*)(?=\"\})','g')

This takes the From column of the Gmail pack, converts it to text as above, then uses regex to extract the email from it.

With the example above it would return:

Next apply a formula filter to your table.

In my test I have a table called Contacts Temp with an Email column.

Using this formula it will filter to only emails related to my known email addresses.

I hope that this helps.

All the best.



Hi @Dale_Cowling ,

Yesterday @Scott_Collier-Weir showed me the ParseJSON function and that goes even faster than your impressive Regex :wink: .

Cheers, Christiaan


Brilliant. That is a much cleaner solution. Thanks @Christiaan_Huizer.

I didn’t even think of that having no experience with JSON myself. I did have a lot of fun figuring out the Regex though :grinning:

For anyone looking in future, I implemented Christiaan’s suggestion but you have to reference the pack directly and not the From column in the pack table, even if it is the same thing.

This works: image

This does not: image

Even though the column is:


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.