cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Submitting a value to a lookup field

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

 

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Submitting a value to a lookup field

Hi @Hepworthnot,

 

I will investigate the issue later and thanks for your patience.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I
Helper I

Re: Submitting a value to a lookup field

Hi Mona,

 

have you had a chance to look at this one for me?

 

Thanks

Phil

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,270)