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 for your suggestion. We are currently looking into this feature.
I will update this ticket when we have more to share.