Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Pagelist - How to select really all rows?

Posted on by 45

Hi,

Our customer uses pre-defined filters in the Posted Sales Invoices (143, List), using 'select all rows' to send the invoice by email or print. (or any other action)

When pressing 'select all lines', only the lines that are visible (loaded in the page) are checked. However, a section is not actually highlighted, because even more lines become visible when scrolling.

As a result, only part of 'all selected lines' will be marked when sending the emails (or printing).

We are aware that the records are partially visible for performance reasons and are loaded as you scroll further down.

But how can anyone actually select all the lines in a normal way?

Thanks

Kind regards,

Jeffrey

  • Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: Pagelist - How to select really all rows?

    if you know the total no of records, you could continue copy the rest. This is not the most elegant way, but works if the total amount is manageable. otherwise, consider use config package as suggested by Kaspars.

  • Peter F. Profile Picture
    Peter F. 34 on at
    RE: Pagelist - How to select really all rows?

    We got the same problem and at the moment, on standard, the only solution is configuration packages.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Pagelist - How to select really all rows?

    You can use Configuration packages - it will export to excel all entries. 
    Or create a custom export.

  • RE: Pagelist - How to select really all rows?

    Hi,

    When CTRL+A is pressed, then CTRL-C, the message shows the number of copied rows.

    pastedimage1686297415182v2.png

    After scrolling down, I noticed the page is filled up with additional records, then pressed CTRL-A and CTRL+C shows a differtent no. of rows

    Even on pressing CTRL+END and CTRL+A, the no. of records isn't correct.

    When we export the records (including the used filter) we retreive 400+ records.

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,437 Super User 2024 Season 2 on at
    RE: Pagelist - How to select really all rows?

    you can try a workaround:

    first you run the table in BC instead of viewing/selecting directly on the page.

    Check how many rows the table have, then Control A while scrolling down.

    If it doesn't copy everything, then try again.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,133 Super User 2024 Season 2 on at
    RE: Pagelist - How to select really all rows?

    I provided the custom solution based on your comment that standard solution doesn't work.

    I tried Ctrl+A and also select more and clicking on the top left icon and in both cases it selected all records that are not on the list.

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: Pagelist - How to select really all rows?

    CTRL+A  should select all rows, but it could work the same as select all... can try.

  • RE: Pagelist - How to select really all rows?

    We are more looking for a standard solution

  • Mohana Yadav Profile Picture
    Mohana Yadav 59,133 Super User 2024 Season 2 on at
    RE: Pagelist - How to select really all rows?

    Create boolean field "Selected" and add an action called select all which makes selected to true

    use that boolean in your code for sending records.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans