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, ... / SOP User Defined - Cha...
Finance | Project Operations, Human Resources, ...
Suggested answer

SOP User Defined - Change Text to Drop Down or Lookup

(0) ShareShare
ReportReport
Posted on by JL-23101911-0
Hello!
Has anyone ever modified an SOP User Defined text field into a lookup or dropdown?  Many reports and years of history are tied a text field, so moving to a lookup field is not an option.  We want to prevent users from miskeying data. 
Thanks. 
Jim
/SOP
I have the same question (0)
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,082 Most Valuable Professional on at
    SOP User Defined - Change Text to Drop Down or Lookup
    There are a number of ways you can make this work.
     
    I would recommend using Modifier to change the window and then using GP Power Tools to add the business logic (because VBA is End of Life).
     
    The next question is.... Is the list of valid values hardcoded or is it read from a table (and therefore easily changed by an administrator).
     
    Methods:
     
    1) Validate the Text Field so it only allows specific values.
    2) Validate the Text Field and add a Lookup which shows the list of specific values from a table.
    3) Change to a drop down list, with hard coded values stored in the local field definition.
    4) Change to a drop down list, with dynamic values populated by code.
    5) Change to a drop down list, with dynamics values populated from a table.
     
    The options are limited only by your imagination.
     
    GP Power Tools Portal: http://WinthropDC.com/GPPT.
     
    Let me know if you want this changed as a demo, it would take no more than 30 mins for the most complex approach.
     
    Regards

    David
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at
    SOP User Defined - Change Text to Drop Down or Lookup
    HI Jim,
     
    Yes this can easily be done. I have already done this kind of customization for many clients. If you are looking for someone who can do it for you, I am available to offer my services.
     
     

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 582 Most Valuable Professional

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 542

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans