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

[Pch]

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 .

I hope this helps