cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerapps890
Post Prodigy
Post Prodigy

Remove data from sharepoint on submission

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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:

1.JPG

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

View solution in original post

3 REPLIES 3
Drrickryp
Super User II
Super User II

@powerapps890 

Where are you putting the remove function?

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
Community Support
Community Support

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:

1.JPG

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

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (65,714)