Hello everyone, I'm wondering if is there a way to automatize one reccurent thing. Every 1st day of the month, i have to send an e mail to a specifial adress mail , the mail content an exported excel file of the billing milestones of the previous month from this view :
Best regards
Hello,
That looks like a good use-case for Power Automate.
Hi Archetype,
As Andrew said, power automate can create a schedule flow.
Go Power Automate(https://us.flow.microsoft.com/en-us/ )
Set trigger as 1st day of each month.
And flow can send email but it can't export view to excel dynamically.
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Hello, thnks for your answers, so there is no way to export dynamically views to excel :( ?
What about adding an HTML table to the email? In Power Automate you can make a table, then put it into the email send.
powerusers.microsoft.com/.../200194
Power Automate is the best fitting solution for:
1. Scheduling.
2. Work with the collection of records/building the table.
If you're not satisfied with the answer given you can keep digging or start following the suggestion given.
Hello, thanks you very much mates for your answers, i will try to do it with Power Automate.
Happy new year to you mates :)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
MVP-Daniyal Khaleel 64
CU29080825-0 16
mk1329 16