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.

Accepted answers

Hayk

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

All comments

Hayk

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.

taqyyudin

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.

Hayk

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

taqyyudin

Invalid formula popup

taqyyudin

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

Quick Links

Can you help?

Unanswered questions

Update email id
Can anyone please explain how to update my registered email ID jn Anaplan.
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…