I have setup an Excel Spreadsheet in our Teams file tab and have inserted a Form which collects and enters the information. We use this to collect information from visitors which for GDPR reasons must be deleted after 21 days.
We have set up a flow in Power Automate that automatically accesses the spreadsheet each day and deletes any entries that are older than 21 days. However, annoyingly this deleted data still seems to exist within the Form itself - when you click on "View Results" all of the entries and data are visible, despite being deleted from the excel spreadsheet. How can this be? Where is this data being stored if not within the spreadsheet?
As it stands we have no way of automating this delete process - I have to manually delete expired entries within Forms each week.