Answered

Remove data from sharepoint on submission

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Where are you putting the remove function?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :
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

Was this reply helpful? Yes No