In order to make it simpler, I removed include statement and added apps resource into the databricks.yml file.

# This is a Databricks asset bundle definition for a-simple-app.
bundle:
  name: app_example

workspace:
  root_path: /Shared/bundles/snri-bundle

sync:
  paths:
    - app

resources:
  apps:
    my_app:
      name: "my-streamlit-app"
      source_code_path: ./app

targets:
  dev:
    mode: production
    default: true
    

Deployment output and folder structure:

app was deployed successfully:

still getting No Source Code error message: