You’re offline. This is a read only version of the page.
19
Hi,
I have created an app which has the data source as 2 separate SharePoint lists on different sites.
I have a new mode form which collects information from one of the sharepoint lists and saves it to the other sharepoint list via a comobobox and concat the values to a multiline text field:
Left(Concat(ComboBox4.SelectedItems, 'Name of information asset'&"|"),Len(Concat(ComboBox4.SelectedItems, 'Name of information asset'&"|"))-1)
This then populates another column of the sharepoint list with the ID from the combobox selected item:
Left(Concat(ComboBox4.SelectedItems, ID&";"),Len(Concat(ComboBox4.SelectedItems, ID&";"))-1)
When on edit mode, I have managed to create a combobox where the default selected items is populated from a gallery which splits the multiline text field:
RenameColumns(Gallery2.AllItems,"Result","Name_x0020_of_x0020_information_")
However, the defaultselecteditems is not populating the ID for the other column although it recognises there are default selected values. I am getting the ";" for the amount of default selected values that there are, along with the ID of any new selected items.
Left(Concat(ComboBox1.SelectedItems, ID&";"),Len(Concat(ComboBox1.SelectedItems, ID&";"))-1)
I just need to bring back the ID of the default selected items.
Thanks
Hi @BSahota :
Could you tell me:
Because of the lack of information, I cannot determine what caused the problem. I have the following suggestions:
I suggest that you do not use
Share
Report
All responses (
Answers (
RenameColumns(Gallery2.AllItems,"Result","Name_x0020_of_x0020_information_")
as the default property of the combobox. Because the data structure of Gallery2.AllItems is different from the data structure of the data source of Gallery2, it also contains the data information of the controls in the Gallery2.Instead,you can try:
Filter(YourComboBox1DataSource,ID in Gallery2.AllItems.ID)
Best Regards,
Bof
