Find List Item based on Property

Options
cfoley
cfoley Member, ALL USERS, Community Member, Community Pioneer Posts: 3 Master Anaplanner of the Year
in Planning & Modeling

This is probably straightforward, but I'm struggling with it...

 

I have a module that includes historical department names, which are combinations of numbers and text, i.e. "5100 Engineering".  Sometimes the department names change, for example "5100 Engineering" might become "5100 Core Engineering".

 

I want to create a list formatted line item in the module that looks up the current department name based on the 4-digit number that proceeds the name.

 

The "active" department list contains a property that isolates the 4 digit string ("5100"), and the module contains a line item with the same string ("5100").  Both the list property and module line item are currently formatted as text.

 

Any tips of how to use those two values to find the list item?

 

Thanks,

Chris
Tagged:

Comments

  • cfoley
    cfoley Member, ALL USERS, Community Member, Community Pioneer Posts: 3 Master Anaplanner of the Year

    Thanks for the responses @PaulRitner and @LipChean_Soh.  I was actually able to solve my issue by adjusting the Code in the Department list to just include the numerical string, not the string + name... I'll think about / look into converting the list to a numbered list when I have more time! 🙂

Categories