Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Is there a better way ...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Is there a better way to handle state lookup fields?

(1) ShareShare
ReportReport
Posted on by mcrthomas 148
Our Dynamics 365 Sales platform syncs with our project management system. The state field in the PMS can only sync with the state lookup field in Dynamics. However our website submission form uses a text field for the state. In order to populate the state look up field with the state text field, I started building the workflow in the image below. It's a pretty basic cascading flow, but I have to believe there's a better way than having 50+ choices. In excel I would use IF or SWITCH to make this work. In our former CRM I used CASE formulas to build things like this. Any recommendations for an alternate workflow? 
 
  • mcrthomas Profile Picture
    mcrthomas 148 on at
    Is there a better way to handle state lookup fields?
    I ended up teaching myself how to use a Sharepoint list of 50 states. The list has the full state name, the abbreviation, and the state ID from the Dataverse table. Now when a new address is added, I just need to look at the share point list for either the full or abbreviated state name and then update it with the state ID.
     
     
     
     
  • mcrthomas Profile Picture
    mcrthomas 148 on at
    Is there a better way to handle state lookup fields?
    Thanks for the reply Jimmy, but this would still require the creation of 50 actions, more if we include Canada. I'm wondering if there is a scenario where I could use a formula or checking the state name against a sharepoint list. 
  • Suggested answer
    Jimmy Passeti | MVP Profile Picture
    Jimmy Passeti | MVP 280 on at
    Is there a better way to handle state lookup fields?
    Hello,
     
    I can´t see it in the image, but I assume you are validating the name of the state in the conditions.
    What can be done is to use the "List rows" action for Dataverse, using the name as a filter and returning the searched line, then use it to update the record.
     
    Regards,
    Jimmy Passeti
    ✅ Please mark as Verified if this answered your question!

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans