Easiest way to delete item from a list iteratively

Hey all,

I’m using a FormulaMap to iterate over every row but the one I’m on, so something like

Table.Filter(CurrentValue!=thisRow).FormulaMap()

Then I want to go and delete my name from a list. I wanted to use .Filter() but that doesn’t work if my name isn’t on the list. In that case I have to use an IF() statement which gets super clunky. I was hoping something failed gracefully. I tried thisRow-User() but it deletes everything in the column.

Beyond the IF() statement being clunky and looking for something cleaner, I also get an “Unable to execute invalid action” when trying to do a Null result on a FormulaMap, so I had to do another ModifyRows() for a fake column just to make it work. How can I fix that??

Test.Filter(

CurrentValue!=thisRow).FormulaMap(

IF(CurrentValue.Voters.Contains(User()),

ModifyRows(
CurrentValue,
Voters,
Voters.Filter(CurrentValue!=User())),
ModifyRows(CurrentValue, [Column 3], “good”)))