Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

How do I get the customer number that selected by user through customer name

Posted on by 20

Hi, all

When user select one row in the list, Customer name will be display on it ,and I need use the Customer Number as a condition to select data from DB, Now the problem is I can not  get the number in the contract or data provider. anyone can help me ?

pastedimage1662712043451v1.png

Best regards.

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How do I get the customer number that selected by user through customer name

    I am still not able to understand your issue?

    Filters works only for the fields that are first added via "addLookupUpField" method.

    If you add customer name you can search by name and if you add customer number you can search by number - Both wont work at the same time.

    Is this the issue you are asking?

    Thanks,

    Girish S.

  • richard man Profile Picture
    richard man 20 on at
    RE: How do I get the customer number that selected by user through customer name

    The problem is SysTableLookup method can return  only one item at once.

  • richard man Profile Picture
    richard man 20 on at
    RE: How do I get the customer number that selected by user through customer name

    Hi, GirishS

    First of all, thank you for your reply, my request is that the user can see the name and number at the same time, when the user enters the customer name in the search box, search by name, when the user selects one, the page displays the customer name, and at the same time uses the customer number in the data selected by the customer as the search condition.

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How do I get the customer number that selected by user through customer name

    Hi richard man,

    You need to get the customer number from customer name?

    You can get customer number from the customer name but the customer name wont be unique sometimes.

    So it will be better to add the customer number in the report instead of customer name.

    Thanks,

    Girish S.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans