web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : JrbNOZ6yX9Y6Nf3SEdwOa8
Power Automate - General Discussion
Unanswered

Scheduling extract data from specific View in Dynamics 365, add records to Excel file, and than send file by email

Like (0) ShareShare
ReportReport
Posted on 22 Sep 2023 10:48:24 by 2

Hi everyone,

I would like to extract data, in Excel static worksheet, from specific View every day with scheduling.

Could I use Power Automate?

If no, It's possible with any HTTP request?

If no, It's available any other solution? by default or custom?

 

I would like data by View, because if View change columns or filters, I don't need to modify my flow.

Thanks. 

 

image.png

 

  • ruvido-saggi-38 Profile Picture
    2 on 25 Sep 2023 at 08:25:15
    Re: Scheduling extract data from specific View in Dynamics 365, add records to Excel file, and than send file by email

    Dear,

    I would like a schedule flow (every day)..

    Data Extraction in excel in specific View (If I change column or filter in View, flow query will change automatically)..

    I don't need button on model driven, this flow will be automatic and scheduled flow (if possible in power automate)...

    The  results will be similar like "button extraction in Excel - Static worksheet".

    But a specific user, will be receive on email this data extraction automatically (even in case of absence or holidays).

    Is this possible in anyway?

     

  • Michael E. Gernaey Profile Picture
    46,673 Super User 2025 Season 2 on 25 Sep 2023 at 05:26:12
    Re: Scheduling extract data from specific View in Dynamics 365, add records to Excel file, and than send file by email

    Hi,

     

    Do you mean, while on a specific View, you want a button or something, that the user can trigger to get data and where do you put it???

     

    Yes you can easily use Power Automate to get data from Excel from a Model Driven app.


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2