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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to display records on a new page based on Header and LIne

(0) ShareShare
ReportReport
Posted on by 54

Hello!

I am trying to create a new page that display the sales line items based on the approval status on sales header page. 

I am using Setrange and Settableview but it doesn't display a set of records and just the first one.

Any Idea how to achieve this?

Thank you in advance!

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    11,407 Super User 2026 Season 1 on at

    hello

    filter your page like this on the header, the subpage of the rows you can filter pr Type= item

    pastedimage1671178536736v1.png

    if instead it is a dry list on the rows that have a certain Status approval in the header, then you have other solutions

    1 . you can build an AL query and read it into the page
    2 . you can filter the rows in AL and mark the recod if the header matches your interests
    3. you can create a flowfield on the rows by recoding the status field in the header, but remember that filters on flowfields can slow down the opening of the page

    DANiele

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,084 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans