Hi,
I have a Sharepoint List back end and a Combo Box on a form where the items value is a concatenation of a number of columns.
for example i have following columns ID, ColA, ColB
By using the following in the Items parameter (ForAll('SharepointList',Concatenate(ColA.Value," - ",ColB.Value)))
This is displaying perfectly
What is not working is the ID of selected not being passed back to the Sharepoint List. The field is blank on the back end list
How do i tell the form in either add or edit mode what columns to pass back?
Thanks in advance
Todd
Edit: ive just found this post which almost has it but I gues I need to "unconcatenate" the values first
Edit: my combo box would only ever have 1 selection but I basically need to perform a lookup that has 2 components
1st part of concatenated value must equal value against colA and second part of concatenated value must equal ColB to get the id that needs to be passed