Skip to main content

Notifications

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

how can I add (populate) value from lookup string Field to another String field.

(0) ShareShare
ReportReport
Posted on by 208

I have two fields in form one is with lookup string field and other is string type blank field ,in lookup drop down it shows "Product Number" and "Search Name"

if I select "Product Number " "0001" from product Number field it should automatically populate "Search Name" to my "Product Name" field.

Below pictures will elaborate what i am trying to say.

.Cdiid.PNGCapturididi.PNG

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    Girish,

    such a nice person you are.

    how many times do i have to thank you ?:)

  • Verified answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    This is because "CHI" county belongs to CHE country region. To get description you have added code based on the country region particularly to USA.

    But generally, county will be used along with state and country region id.

    To fix this issue we can convert that to select statement and add only county id in where condition. But there will be same county exist for multiple states and country regions.

    I suggest you clarify this with functional after changing it like below.

    LogisitcsAddressCounty addressCounty;
    select firstonly * from addressCounty
        where addressCounty.CountyId == this.CountyId;
    this.CountyName = addressCounty.name;

    Thanks,

    Girish S.

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    3365.cc.PNGccc.PNG0525.cccc.PNG

    here is my problem , 

    in lookup it shows me country names from every country/region, but displays only  "county" and "Description" from country/region "USA" 

    as i have clicked on "CHI" it only displayed county but description is empty. 

    i want it to display for every region But not not specified for USA. 

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    If the lookup is from EDT then it will show all the county Id irrespective of the country region id.

    Normally county Id lookup will be based on the selection of country region id and state. You can refer to standard address creation form for customer - vendor - worker.

    Thanks,

    Girish S.

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    Girish,

    I have added string type field to my table and set its EDT to "LogisticsAddressCountyId",

    so it is coming from EDT.

    thanks

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    How you write lookup for county Id? Or the lookup is coming from EDT?

    Thanks,

    Girish S.

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    then how specificialy I have to do it ?

    I have tried my knowledge but it didn't help.

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    It depends upon how you have added lookup for County Id. If you don't add any range to country region, then it will display against all country regions.

    Thanks,

    Girish S.

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    This is acceptable and it is  working . but what if I have to  show data against every region , now it is just showing data against USA region.

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: how can I add (populate) value from lookup string Field to another String field.

    Oh, sorry I wrongly typed the EDT name. It is LogisiticsAddressCountryRegionId.

    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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans