topic Re: Property Set Lookup in Civil 3D Forum

Property Set Lookup

Valentin_Belets — Fri, 06 May 2022 07:35:28 GMT

Hi all,

Could find a solution to seemingly simple task I am trying to achieve.

Essentially, is it possible to use a formula in property sets to lookup a value from an array of values? Something similar to Excel lookup?

I've got a list of values I'm providing using a list definition, and I would like to implement a lookup of another value from a config table.

And just generally, is there a reference guide somewhere for the formulas we can use for Property Definitions? I've only found those which are dealing with extracting civil 3d database object properties, but I'm interested in some more trivial ones.

Any help or pointers to sume supporting resources would be much appreciated.

Regards,
Val.

Re: Property Set Lookup

samir.rezk — Fri, 06 May 2022 18:17:30 GMT

Hi @Valentin_Belets

You can do something similar to a lookup by creating a List definition first (to compose a list of items) and

then reference that list as the source for the property set attribute.

Hope this helps,

Re: Property Set Lookup

Valentin_Belets — Fri, 06 May 2022 20:36:55 GMT

Hi Samir,

this is exactly what I did for the values in the red box in my screenshot.

I just wanted for the respective values in the green box to be looked up in another property definition.

Re: Property Set Lookup

samir.rezk — Fri, 06 May 2022 21:25:13 GMT

Hi @Valentin_Belets

I understand better now what you'd like to do! Lookups are not a native function in Property Sets, but I did find this thread with a similar situation, not sure if you came across it already!

Solved: Property set formula property: Lookup value from file - Autodesk Community - AutoCAD Architecture

Also, Dynamic Block lookup table might be a good option, if you're working with Blocks! as opposed to Property Sets.

Hope this helps,

Re: Property Set Lookup

rl_jackson — Thu, 21 Jul 2022 15:22:58 GMT

@samir.rezk

I created a lookup/list that has multiple values in each list to define various items, as shown below.

However, when I go to my point label style to apply the items that are part of the list within the label style they don't appear in the selection list, is there something I'm missing or does this function not exist.

Thanks, Rick

Re: Property Set Lookup

samir.rezk — Thu, 21 Jul 2022 17:02:56 GMT

Hi @rl_jackson

List definitions do not show up in the drop down menu in the label style composer automatically, however we are able to write the label code directly. type the following:

<[PSD Name:PS Name(CP)]>

Based on your screenshot, an example will look like:

<[Structures:A_Direction(CP)]>

CP means case preserved, this can be changed to CU or CL

same code applies for creating table styles!

Hope this helps,

Re: Property Set Lookup

rl_jackson — Thu, 21 Jul 2022 19:06:55 GMT

Thanks @samir.rezk that was very helpful, I honestly didn't even think about hard typing it. I also would not have thought the list would be any different than the normal property set and its exposure to the label style.

Re: Property Set Lookup

essam-salah — Wed, 11 Feb 2026 11:13:06 GMT

Hi,

you can do lookup directly from excel using VBA, and lookup value from another Property