I have a table with purchase invoices and one with invoice items (“Items In”).
I deleted some of the items of each invoice and now the lookup field is cluttered with “Deleted Row” pills. How can I remove them?
I know I can hit backspace on the entire cell, but I want to only delete the links to the “Delete Rows”, without affecting the existing rows at all (which are themselves already links to other stuff that I don’t want to break”.
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 .