Hello @Andrea Previtali ,
the direct answer is to execute deletion logic using eg. a timer-triggered Azure Function or an Automation Runbook:
var query = new TableQuery<MyEntity>().Where(TableQuery.GenerateFilterCondition("MyField", QueryComparisons.Equal, "Foo"));
var rows = groupsTable.ExecuteQuery(query);
foreach (var row in rows)
{
var tableOperation = TableOperation.Delete(row);
table.Execute(tableOperation);
}
The longer answer is to reconsider Azure Table storage.
Check out other database options like Azure Data Explorer (It sets a retention time by default. There is a free tier), giving you more flexibility.
If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.