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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Statement to use Looku...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Statement to use Lookup table when retrieving data

(0) ShareShare
ReportReport
Posted on by thesar 32

I have a customized lookup table like this:

Country Notes
Germany German notes
Italy Italian notes

What i want is that my report will fill the node "Notes" with notes depending on from which country the customer is.

For example, if the CountryRegionID for for the customer is GER, i want it to check it in the lookup table, and take the source from "Notes" that is in the same row as Germany. How would this be possible? can it be solved by using an expression?

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,662 Most Valuable Professional on at
    RE: Statement to use Lookup table when retrieving data

    One option is not duplicating the value are merely displaying it from the setup table (by using a join or a display method).

    If you want to copy the value, think about at what time it should happen. If immediately when you change the country, modifiedField() method on the table is a good choice.

  • thesar Profile Picture
    thesar 32 on at
    RE: Statement to use Lookup table when retrieving data

    This will be on PackingSlip level, will be used as a Pro Forma for Customs. But i need the notes to be different depending on country. So the solution i cam of thinking is having a lookup table with the key being the country and the notes being the data i am needing. so if i am sending a pro forma for a customer from germany then i want the ER to take the german notes from the lookup table and insert it to my Note field in the model mapping.

    Still havent found a good way though.

  • Suggested answer
    Arcadi Profile Picture
    Arcadi 794 on at
    RE: Statement to use Lookup table when retrieving data

    Declare your table registry in the maping of your XYZ_YourTable, then use the formula (on a new field and it the same level of where you have the CountryRegionID):

    FIRSTORNULL(
    FILTER(
        XYZ_YourTable,
        XYZ_YourTable.Country = @.CountryRegionId)).Notes

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 724 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 400 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans