Removing Duplicates by Email using a button

1

Hello,

I have a pretty basic contact sheet table and I’d like to be able to identify and eliminate duplicates based off of email address column.

I came across this post but the formula did not work in my case.

What action formula can I write to search for and eliminate rows with duplicate email addresses that occur later in the “Row ID” column or as newer in the “Date Created” column?

You help is much appreciated.

2

hello @P_C ,

I splitted the steps to make it easier to follow and added the count (though not needed) for the visual aspect:

the count : thisTable.Filter(email.Contains(thisRow.email)).Count()

the first: thisTable.Filter(email.Contains(thisRow.email)).First()

to keep: thisTable.Filter(email.Contains(thisRow.email)).First().Contains(thisRow)

image
image1762×1378 152 KB

the button goes as below:

image
image1940×1355 163 KB

Enjoy your day, best, Christiaan

1 Like
3

I don’t understand the utility you’re serving by adding a “The First” column in your example, nor do I understand the formula.

However, I was able to appropriate your “to keep” formula well enough and it marks it seemingly as I intended it to.

Do you of way to remove the hyperlink in the emails column automatically?

4

As long as it works, understanding is secondary I guess.

I assume you want to push only one button to have only unique email addresses in text format. I borrow some insight from @joost_mineur:

  • that is a good start to first delete possible spaces (you do not see, but can be there) using Trim()
  • how to use a ModifyRows in combi with a CurrentValue without using Nth()

The name of the table is duplicates and the button links to this table and executes 3 actions: We skipp the edu part, enjoy the formula:

RunActions(

duplicates.FormulaMap(CurrentValue.
ModifyRows(email,CurrentValue.email.ToText().Trim())),

DeleteRows(Filter(duplicates, [to keep]="false"))

)

image
image1957×1407 194 KB

best, Christiaan