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

Pagelist - How to select really all rows?

(0) Share

Report

Posted on by proceed-it-solutions

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

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Mohana Yadav 61,242 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
proceed-it-solutions 65 on at

Like
a
(0)

Report
Copy link

Link copied!

We are more looking for a standard solution

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,842 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,242 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,220 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
proceed-it-solutions 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

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

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.

Was this reply helpful? Yes No
KasparsSemjonovs 4,842 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Peter F. 34 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jun Wang 8,220 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No