Remove data from sharepoint on submission

[powerapps890]

I want the items in the sharepoint list for that specific user to be deleted when the submit button is pressed. I have a statement identical to this in another app and it works perfectly Remove('CPQ Radio', Filter('CPQ Radio', 'Created By'.Email = varUserEmail)). This one is using radio buttons. I just want the sharepoint list to always have the most recent data from that user.

[Drrickryp]

@powerapps890 

Where are you putting the remove function?

[powerapps890]

It is outside of the gallery. It is the button that patches all the selected radio buttons answers which I need to remove with each new submission. @Drrickryp 

[v-bofeng-msft · Accepted solution]

Hi @powerapps890 :

Could you tell me:

• What is varUserEmail's value?Is it a user's email address stored as a string?
• How many records are in'CPQ Radio'?

I assume varUserEmail  is a user's email address.

Firstly,this formula cannot be delegated.

In order to avoid delegation issues as much as possible, I suggest you adjust the value of data row limit for non-delegable queries to 2000.

Secondly,'Created By'.Email can not be used as a string.

I did a similar test and the following error occurred:

Finally,please try:

Remove('CPQ Radio', Filter('CPQ Radio', varUserEmail in 'Created By'.Claims ))

Or

Remove('CPQ Radio', Filter('CPQ Radio',"i:0#.f|membership|"&varUserEmail = 'Created By'.Claims ))

Best Regards,

Bof