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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (100,649)