Hi guys,
Here's my scenario.
We have a form with a lookup field which connects to a Dataverse table that has 3 columns, I need to figure out a way to obtain values from all 3 columns (not just the lookup column). The objective is to allow the user to select a shipment reference from the lookup (which is populated onto the lookup box labelled Target Job), and for 2 other values on the same row to be obtained and auto populated, onto two read only fields; labelled Consignee and Consignor (these can be text boxes or dropdowns). The below image shows the 3 columns and the values which we require from each row.
The first column is not a problem as this is the lookup (primary column), in our use case this column gives us a shipment reference number.
The challenge is with the next step, we need to also grab the consignee and consignor values which are in the 2nd and 3rd column respectively. As far as I am aware, the lookup will only point to the primary column, and there is no way to obtain values from any other column.
I have tried multiple ways with Jquery, but I have not found a way to achieve this, I am only able to duplicate the lookup column shipment reference number onto the consignee and consignor text boxes (as shown on the 2nd image below), there does not seem to be a way to obtain the consignee and consignor values associated to the lookup column shipment reference, and auto populate this to the consignee and consignor text boxes.
Is there a way I can use Jquery to achieve this? If this is not possible with Jquery, how would I accomplish this using FetchXml and liquid code?
I am relatively new to Power Pages, Jquery, FetchXml and Liquid code. I did attempt to use FetchXml combined with Liquid code, but I couldn't figure out the correct syntax for what I am trying to achieve.
The Jquery syntax which I am currently using (only duplicates shipment reference from lookup column) is listed below (part of the Dymanics 365 environment name has been replaced with 'xxxx':
$(document).ready(function(){
$('#xxxx_target').on('change', function() {
$('#xxxx_consigneeauto').val($('#xxxx_target_name').val());
$('#xxxx_consignor').val($('#xxxx_target_name').val());
})
});
Target is the lookup search element name, consigneeauto is the text field intended to be used to autopopulate the consignee value, consignor is the text field intended to be used to autopopulate the consignor value.
Any advice would be greatly appreciated, apologies for making this post long; I wanted to make the scenario clear.
Thank you.
