Yes, this can be automated in Dynamics 365, but the easiest approach depends on whether you want to send the view data or an actual report file.
For a simple Dynamics 365 view, Power Automate is usually the most flexible option:
Scheduled cloud flow → Get rows from Dataverse → Create HTML/Excel output → Send email
For your requirement, you can schedule the flow to run every Monday morning, retrieve the records matching the same criteria as your Dynamics 365 view, format them as an HTML table, and send the email to the required sales users.
If you specifically need an Excel attachment, the flow can instead populate an Excel file or create a CSV and attach it to the email.
If you're using a Power BI report, Power BI's subscription functionality may be a better option because it can automatically send report snapshots to users on a schedule.
For a Dynamics 365 model-driven app view, I would recommend Power Automate + Dataverse rather than trying to email the view directly. It gives you much more control over the schedule, recipients, filtering, and email format.
The basic flow would be:
Recurrence (Every Monday)
↓
List rows (Dataverse)
↓
Create HTML table
↓
Send an email (Outlook)
You can use the same filtering criteria as the Dynamics view in the List rows action so that the email contains exactly the records you want.
