Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Alternative entity list view in download

(0) ShareShare
ReportReport
Posted on by 2

Hi'

Does anyone know of a way to change the default view of an entity list when downloading as Excel?

I have a case, where I want the download button to utilize a much richer list of columns than the list presented to the user. But I don't want to bother the user with manually changing the view (resulting in an ugly list with far too many columns) before downloading. 

I thought up a couple of "solutions" myself but would like to hear your input before choosing the right strategy. Perhaps there's a way simpler path than I thought... :-)

  1. Including alle columns in the displayed view, but removing the one I don't want the user to see by javascript by hiding the corresponding <th> and <tr>'s
  2. Including two views, but hiding the view selector and programmatically change the view hen the user clicks "download"
  3. Implementing my own Excel-download feature based on javascript Excel-exporter with data generated by a FetchXML
  4. Your idea... :-)

Anyone has an idea? 

  • Suggested answer
    Fubar Profile Picture
    2,752 on at
    RE: Alternative entity list view in download

    One option is to create a second Entity List and only expose the 1 view, and create a 'Download' menu item for it, and also put a link on the existing page (with view selection capability) click here to download data.

  • Akanksha Srivastava Profile Picture
    100 on at
    RE: Alternative entity list view in download

    Hi Jan,

    May be you can add a custom button that calls for a Power Automate flow. The flow can refer to the view you want and email the extracted list of data to the requesting user or upload on a SharePoint/ Teams page.

    Regards

    Akanksha

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Alternative entity list view in download

    Hi Jan,

    The easiest option would be to expose another view on the entity list. There can be multiple views. The user could select that view for exporting.

    pastedimage1617269341975v1.png

    The default view that shown in the portal is first view.

    pastedimage1617269410472v2.png

    Then 'Download' button will only download the view displayed in the current page, so you can make user change another view to download it,

    pastedimage1617269587748v3.png

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,269 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans