Hi,
I have a list Note with a required lookfup field MatterLookup to the ID field of a list called Matter.
I want to submit a new Note with a prepopulated value for MatterLookup.
I have tried setting the default value of the MatterLookup field on the Note edit form to:
{'@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
ID:Gallery1.Selected.ID,
Value:Gallery1.Selected.Title}
It doesn't work. Sometimes I succeed in submitting a new Note record but when I look at the entry in SharePoint the MatterLookup field is empty with a alert that a required field is missing.
I have tried setting the default value to the card, to just the drop down and to both. I have changed the Value1 and Value2 options around every which way.
All the solutions I have seen on the web suggest the approach above but I simply can't get it to work.
Help would be greatly appreciated.
Thanks
Phil