Bot - delete child items without parents

[StephenSaid]

I have a bot that runs daily to delete any children items without a parent.

These usually happen during development only.

The bot is throwing an error.

The flow is:
Event: Daily... nothing else

Process: A process that deletes a row from the table and a lookup with the following expression:

FILTER( "Transfers", ISBLANK([TransfersHeaderID]) )

I have a feeling that this expression is the issue.

Any help is much appreciated.

[WillowMobileSys]

It's hard to know what might be causing the error without knowing more about your data structure.

I'm not sure if this helps but AppSheet has the capability of a "tightly coupled" Parent/Child relationship.  This is accomplished by setting the "Is part of" property in the Child table on the column that is the Ref pointer to the Parent row.

With this setting turned on, anytime the Parent is deleted, all associated child rows are also deleted.  This eliminates the needs of having a Bot looking for orphaned child rows.