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.