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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Clear Data from the table
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Clear Data from the table

(0) ShareShare
ReportReport
Posted on by AhmedSaeed 383

Hello every ,

i create a new form but when filter by any field in this form it delete the data from the table

I have the same question (0)
  • prt33k Profile Picture
    prt33k 6,907 on at
    RE: Clear Data from the table

    Hi Ahmed,

    We need more detail to provide input.

    Did you create a new form for a custom entity?

    Where are you applying the filter - advanced find/view?

    If data is getting deleted did you check to remove all the filters if it wasn't actually getting filtered?

    If it is deleted, then did you check Audit?

    Thanks,

    Prateek

  • AhmedSaeed Profile Picture
    AhmedSaeed 383 on at
    RE: Clear Data from the table

    Hi prateek.

    I create a new table with new form.it working fine in Dev machine but when deploy on sandbox and try to filter by any field it delete the data from the table

  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at
    RE: Clear Data from the table

    You can go through Setting->Auditing->Audit Summary View

    pastedimage1611682222672v1.png

    Then check it there:

    pastedimage1611682301792v2.png

    This will show if the record actually got deleted and which user context it got deleted.

    You need to enable Audit though on your entity.

    Do share some screenshots of how are you filtering and where are you check deleted records if this doesn't help.

    Thanks,

    Prateek

  • AhmedSaeed Profile Picture
    AhmedSaeed 383 on at
    RE: Clear Data from the table

    Hi Parteek , i'm using Dynamics 365 F&o

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 77 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 57 Most Valuable Professional

#3
Anthony Blake Profile Picture

Anthony Blake 43 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans