Function Remove has some invalid arguments - have tried everything, but still not working

[AnthonyJrJr]

Hi guys,

This is driving me insane. I want to delete a record from Gallery.

I'm trying to delete a record in other SP list based on ID from Gallery (Gallery is feed from different list).

I manage to get the ID from the SP list where I want to delete that record, but I cannot delete it.

1st picture is showing ID after clicking on the Gallery item

2nd picture is showing exactly that ID in SP list

3rd picture is showing error

I don't understand why I just cannot call the list, give an ID and delete that record, because this is exactly what I'm doing 😞

Thank you!

[RandyHayes · Accepted solution]

@AnthonyJrJr 
The Remove function requires your source table as the first parameter, and the record you want to remove or a table of records as the second.

You are providing the second parameter as an equality formula.  So, it will result in either true or false...which will not be a record or a table, so it is not valid.

If you are trying to remove the record from within the gallery row, then the formula can be: Remove(yourList, {ID: ThisItem.ID}) or RemoveIf(yourList, ID=ThisItem.ID)

You mention that your record is in some other list other than the gallery list, so perhaps the above to options give you a clue.

If not, then post back with a little more detail on where you are performing this function and about the different list and the relationship to the gallery.

I hope this is helpful for you.

[AnthonyJrJr]

@RandyHayes thank you, but now I'm facing other issue. My expression now is correct, but no records are deleted.

RemoveIf(List_Prijave, EmPolaznik = varUser.mail && List_Prijave.TerID = ThisItem.ID)

Incompatible types for comparison. Table and Number.

"TerID" is not default ID of "List_Prijave" SP list, it's some other ID I've passed (one to many relationship).

I'm checking TerID and logged user email in order to delete the record from the list, this should be ok, but nothing happens.