web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Remove records but not...
Power Apps
Answered

Remove records but not rows

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone,

 

I've a question, I've some records in a gallery that are connected to a sharepoint list, that list is also connected to an excel sheet with a flow, my question is, how can I remove the records but not deleting that row (each row of my sharepoint has an ID) with this I'm going to see the row totally empty but not deleted.

 

Hope to hear from you soon,

 

Best regards.

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    155,667 Most Valuable Professional on at

    Hi @Anonymous ,

    A row is a record. Are you simply wanting to remove all information from all fields?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Mr @WarrenBelz ,

    Thank you for your soon reply,

    Actually, I want to delete just only the info in the row, for example:

     

    This is my row in my sharepoint

    ID            Date          Month          Code            Proc.        Name

    6802/03/2020MARCH1-7705012619CALLMARÍA ELENA ROJAS PASANTES


    In my power apps I've this data as a gallery, I would like remove just only the info but not the row, I'll look like this, if I remove the data in the power apps.

    ID     Date Month Code Proc. Name

    68     


    I know there is a formulan which is "Remove" but this one delete all the row and i just want to delete only the information in that row.

     

    Hope to hear from you soon,

     

    Best Regards.

     

    Diego F.

  • Verified answer
    WarrenBelz Profile Picture
    155,667 Most Valuable Professional on at

    Thanks @Anonymous ,

    Firstly, before you do this, go into your app File > Settings >Advanced Settings >Experimental Features and turn on Formula-level Error Management. If you do not do this, the Date will not clear.

    Now it will depend where you run this code from - the example below would be from a button inside a card on the form (you would have to unlock it) or inside a gallery.

    You have not given me your SharePoint list name - I will use MySPList - change to your name. I have also assumed your field names are as per your post. I urge you change the field names Date and Name (reserved words) and take the full stop off proc.

    UpdateIf(
     MySPList,
     ThisItem,
     {
     Date:Blank(),
     Month:Blank(),
     Code:Blank(),
     Proc:Blank(),
     Name:Blank()
     }
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Do you want to clear column values in your SP List rather than remove?

     

    Based on the needs that you mentioned, I agree with @WarrenBelz 's thought almost. The UpdateIf function could achieve your needs.

     

    If you want to clear all records in your SP List, please try the following formula:

    UpdateIf(
     'Your SP List',
     true,
     {
     Date: Blank(),
     Month: Blank(),
     Code: Blank(),
     Proc: Blank(),
     Name: Blank()
     }
    )

     

    Please check and see if the following blog would help in your scenario:

    https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-databases/

     

    Best regards,

  • WarrenBelz Profile Picture
    155,667 Most Valuable Professional on at

    @v-xida-msft  -  this would clear all items of all data.

    My understanding from @Anonymous 's post was for the item concerned.

    @Anonymous please confirm this as there is different code depending on what you need.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Mr. @WarrenBelz  and @v-xida-msft,

    Thank you for your soon answer,

     

    The code that you gave me it works, thank you so much for your support.

     

    Best regards.

     

    Diego F.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 421

#2
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 278 Super User 2026 Season 1

Last 30 days Overall leaderboard