Handling "Deleted Row" in Lookups

[Brian_Sowards]

When you have a lookup column, if the referenced row is deleted it isn’t removed but instead replaced with a phantom “Deleted Row”

This includes when using “Delete Everywhere” on a row.

I’ve tried filtering with the following formula, but it doesn’t work:

[Lookup Column].ToText().Contains("Deleted Row")

But it doesn’t filter to those rows (it did previously).

How do you filter for “Deleted Rows”?

What approach do you use to clean up these phantom records?

[Pch]

Hi @Brian_Sowards !

Depending on your use case scenario, maybe IsFromTable() could help you here ?

How to remove “Deleted Row” references from lookup field while preserving links to existing rows?

Hi @Anna_F ! Maybe a button could help you here : The action could be something like : ModifyRows( thisRow, thisRow.[Items In], thisRow.[Items In].Filter( CurrentValue.IsFromTable([Table where the items are stored]) ) ) It should filter the rows currently in thisRow.[Items In] and only keep the rows from the table where those items are store (IsFromTable()), leaving out the ones you deleted . [Deleted Items] I hope this helps