Vlookup in Newform

[Navya Marla]

Hi Alex,
How can i achieve vLookup functionality in new form?

Thanks,
Navya

[Navya Marla]

Hi Alex,
How can i achieve vLookup functionality in new form?

Thanks,
Navya

[Navya Marla]

Hi Alex,

we tried to analyze the issue to find out the root cause and we came to know that the CAML query in new form is not passing the _vLookup ID.
Please find the below query in new form

<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='_vLookupParentID' /><Value Type='Text'>~_vLookupID~</Value></Eq></Where><OrderBy><FieldRef Name='ID' /></OrderBy></Query></View>

we tried to get the _vLookupID in the parent list in new form using Getfieldvalue.It is returning the correct ID

In edit form

<View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’_vLookupParentID’ /><Value Type=’Text’>8:1470121931290</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ /></OrderBy></Query></View>

Thanks,
Navya

[Alexander Bautz]

Which version of vLookup are you using? – I have addressed an issue with showing vLookup matches form NewForm in vLookup frontend v2.2.70 (July 10, 2016): https://spjsblog.com/dffs/dffs-change-log/

Alexander

[Author]

Posts