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 :
Finance | Project Operations, Human Resources, ...
Answered

ER- LIST vs LISTJOIN

(3) ShareShare
ReportReport
Posted on by 264
Hi experts,
 
Can anyone explain the difference between functions LIST and LISTJOIN. 
 
Thanks 
Pranav 
Categories:
I have the same question (0)
  • Verified answer
    CA Neeraj Kumar Profile Picture
    5,099 Super User 2026 Season 1 on at
    Hi Pranav,
     
    For example:
     
    I have record of CustInvoiceJour, CustInvoiceJour2, CustInvoiceJour3,
    so if i pass these three records in the LIST function, it creates a list with three records.
     
    It also helps in conversion of record to list when we need to compare with same data. As many functions support only LIST as a parameter, so to pass the record we convert the same.
     
    LISTJoin functions supports to create a UNION join using multiple lists. So it differs from LIST functions in this manner that LIST functions takes records as parameters, but LISTJOIN takes record list a parameters.
    for example, we want to club CustInvoiceData, InventTransferJour and make a report with all relevant fields like document number, document date, then we can use LISTJOIN function to make a combined recordlist.
     
    I have lot of different examples, if you need the same, i can share few.
     
    One more thing, not to advertise but for knowledge purpose, you can buy my book "Electronic Reporting - The Hidden Gem", it will give you answers for most of the queries.
     
    I am happy to help you here on MS community as well, looking forward for more such queries.
     
    Regards,
    Neeraj Kumar
    Author of the book - Electronic Reporting - The Hidden Gem
  • Pranav Teja Profile Picture
    264 on at
    hi Neeraj,
     
    Thanks for clarifying. 
     
    I have bought the book you authored. It is very resourceful. But sometimes am getting stuck with nuances, hence reaching out for help.
     
     
    Thanks again.
    Pranav
  • CA Neeraj Kumar Profile Picture
    5,099 Super User 2026 Season 1 on at
    Hi Pranav, 
    Glad to know that you have the book already available with you. 
    Sure, we will try for resolving your queries. 
     
    Regards, 
     
    Neeraj

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 710

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 465 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 317 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans