Creating Master from Child and Parent SP list

[Faye125]

Hi,

I am not sure if this is the right place but I am trying to create a Master list using Child and Parent SP Lists and Lookup Col.

I am patching Parent ID to child SP list and using the Parent ID to lookup parent Info for each child line item. However the lookup col is a manual process (You have to select the Parent ID from drop down). I am trying to automate that by setting lookup default value to: "Thisitem.Parent_ID". However I am getting this error for update value:  "The property on this control expects Record values. The rule produces Text Values which are incompatible". I am using TextInput Field.

Any idea how I am fix this error or a better way to merge Child and Parent into master?

[DylanSimons]

Can you instead pass ThisItem to the function? That would be a Record value.

If that doesn't work, please include your function and then it is easier to help.

[Faye125]

I am not sure what you mean by function. I tried converting text field to Value as follows but that didn't work:

Default as: Value(ThisItem.Parent_ID)

Update as: TextInput2.Value and Value(TextInput2.Text)

[DylanSimons · Accepted solution]

The Default property needs a record value, which is similar to an Item in a SP list.

you can use a Lookup function for that, something like:

Lookup(DataSource, Parent_ID = ThisItem.Parent_ID)

What you are using now:

Value(ThisItem.Parent_ID)

returns a Number. Please see the Value documents if you have any questions on that