Hello,
I have two tables in dataverse: 'CORR infos': with information, 'CORR db': with records. In 2nd table I need a column with a choice of all part numbers from column in 1st table. I have created a form in canvas app to add records to my 2nd dataverse table and I can see a dropdown list with all my parts to be chosen. My patch function seem to be working fine as well but when I look at table after saving I can see only this bit: 'CORR' while it should be a part number starting with 'E50-...'.
DataCardValue3 -> Items -> 'CORR infos'.Part
Bit with code for 'Part' column:
This is what I can see in table after saving:
I have tried many options but non of them were actually working... the column in 'CORR infos is Text format while in my second table the 'Part' column is Lookup format.
I also have a label on side which should show me other info from 'CORR infos' as reference and it's showing me data which I want:
LookUp('CORR infos', Part=DataCardValue3.Selected.Part, Setup_Comment)
Can anyone help with this one, please?
Regards