Cannot export an app due to error

Issue

When you attempt to export an app the export process fails.

Reason

There may be 1 or more orphaned lookup columns in your list. An orphaned lookup column is a column that is no longer connected to its parent lookup list. We have seen this issue occur when the design of a form or app changes over time and 1 or more lookup columns that were used in the initial version of a form are no longer used. If the lookup list is deleted before the lookup column is deleted then the column becomes disconnected or orphaned.

Resolution

If the lookup columns are no longer in use simply delete them and the export will then work for you. Alternatively, if you require the lookup columns you can delete the orphaned ones and re-create them from scratch.