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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

ER- LIST vs LISTJOIN

(2) ShareShare
ReportReport
Posted on by 215
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
    4,392 on at
    ER- LIST vs LISTJOIN
    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
    215 on at
    ER- LIST vs LISTJOIN
    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
    4,392 on at
    ER- LIST vs LISTJOIN
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 865 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans