Skip to Main Content
Status Completed
Categories Form Designer
Created by Guest
Created on Jan 20, 2021

Return data lookup value as object

I have several areas in my forms where I need a data lookup field on my form to return more than one value from the SharePoint list item that is selected.
For example, my Location data lookup field needs to save the location as the value and the label. BUT I also need to save the corresponding Abbreviation (another column in that SP source list) for that location into a different field so that I can use that Abbreviation in a filter on the form.
I have seen Euan's helpful video on a work around but that work around won't work for me since I need both values.
I have also seen where back in April 2020 the dev team was discussing adding this functionality to NWC by having the data lookup value return as an object.
Can you please share where on the roadmap this is planned for?
Thank you.
  • ADMIN RESPONSE
    Sep 7, 2022
    Hello

    This functionality can now be achieved using Data Source Variables (DSV).

    The DSV returns an Object, the values from which can be used within the form.

    Thanks
  • Attach files
  • Guest
    Reply
    |
    Sep 7, 2022
    Fantastic! Thank you!