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?
Solved! Go to 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
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.
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)
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
186 | |
45 | |
45 | |
36 | |
35 |
User | Count |
---|---|
262 | |
83 | |
78 | |
69 | |
67 |