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

2

Hi @Anna_F :blush: !

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 :blush: .

Deleted Items

I hope this helps :blush:

4 Likes