Pull/Lookup data from general list into module with numbered list

Highlighted
New Contributor

Pull/Lookup data from general list into module with numbered list

Dear All,

 

Appreciate if anyone can help me on this.

 

How to pull/lookup data (properties data of Total Area sqf) from a specific general list (Detail Project Component list) into a module (Master Tenancy List) that contained a numbered list with parent hierarchy is Detail Project Component?

 

If not using numbered list, yes it can be done easily.

 

Outcome i need is that when i add new tenant in specific unit lot, information of total area of the unit lot will automatically pulled from the general list.

 

image.pngimage.pngimage.pngimage.png

Message 1 of 6
5 REPLIES 5
Certified Master Anaplanner

Re: Pull/Lookup data from general list into module with numbered list

Hi,

 

You can do it this way:

  • add a property to your numbered list
  • format it as a list (Detail Project Component list)
  • write a formula Parent(Item(*your_numbered_list*)
  • now you can lookup properties from Detail Project Component list using this new created property

Hope I answered your question. 

Message 2 of 6
New Contributor

Re: Pull/Lookup data from general list into module with numbered list

Hi Hayk,

 

Thank you very much for your suggestion.

 

Based on the picture attached hope can you suggest which list item should be *your_numbered_list*

  • write a formula Parent(Item(*your_numbered_list*)

I tried some list but could not work.

 

image.pngimage.png

Message 3 of 6
Certified Master Anaplanner

Re: Pull/Lookup data from general list into module with numbered list

It should be Parent(Item('# Assign master tenancy to Dept & Company'))

Message 4 of 6
New Contributor

Re: Pull/Lookup data from general list into module with numbered list

Yeyy.. it work.. Thanks a lot Hayk.

 

image.png

Message 5 of 6
New Contributor

Re: Pull/Lookup data from general list into module with numbered list

Invalid formula popup
image.png

Message 6 of 6