remove user email from appended list

[SamSellars]

I created this bit of code to append a email to a multiple line list 

Patch(
'TEST It hardware raffle',
First(
Filter('TEST It hardware raffle',Title = ThisItem.Title)
),
{'claimed by': LookUp('TEST It hardware raffle',Title = ThisItem.Title , 'claimed by') & User().Email }

I now need a code that will only remove the current users email from the box and leave the rest.

Remove(
'TEST It hardware raffle',
LookUp('TEST It hardware raffle',Title = ThisItem.Title , 'claimed by',User().Email))

This is what I have tried but to no effect

[Anonymous]

Hi Sam,

You would be better using the RemoveIf statement as opposed to a remove as you won't need to apply a filter or lookup.

So: RemoveIf('TEST It hardware raffle', 'claimed by' exactin in User().Email)

Hope this helps,

Jamie

[SamSellars]

Hi Jamie,

I get a error pasting that line is as it dosnt like having "exactin in" I deleted the in and it allowed me to run but did nothing.

Thanks Sam

[SamSellars]

And I also need to filter to only one row as there email will be there multiple times in the column but only want to delete the one in the correct row

[Anonymous]

Hi Sam,

Exactin should be one word, try it like that as that is the term for comparing strings,

Jamie

[Anonymous]

Hi Sam,

Try RemoveIf(Filter('TEST It hardware raffle',Title exactin ThisItem.Title), 'claimed by' exactin in User().Email)

Hope it helps,

Jamie

[SamSellars]

sorry Im still getting the same error 

[Anonymous]

Hi Sam,

You have in after the Exactin (Sorry I did leave this typo in), try removing it and trying again.

Jamie

[SamSellars]

HI Jamie,

it now says 

RemoveIf(Filter('TEST It hardware raffle',Title = ThisItem.Title), 'claimed by' exactin User().Email);

I have tried 

RemoveIf(Filter('TEST It hardware raffle',Title exactin ThisItem.Title), 'claimed by' exactin User().Email);

neither removes anything and the Remove function works in the same segment but removes the row instead of the text I want 

this is what my entry looks like for that box but instead of test it is user emails 

Sam

[Anonymous]

Ah, so what you need is an update statement,

try this

UpdateIf(Filter('TEST It hardware raffle',Title exactin ThisItem.Title), 'claimed by' exactin User().Email, {'claimed by':""})

Jamie