Hello,
I followed
this video to get a multi select checkbox working in my custom form for a Microsoft List on a SharePoint site. In the video, he uses the following code in the OnVisible property of the FormScreen so if you edit the entry, it opens up the form with the checkboxes selected that are relevant to that entry:
If(
FormWorkTask.Mode <> FormMode.New,
Collect(
colCategoryData,
GalleryTasks.Selected.Category
)
)
I don't have a gallery (GalleryTasks) to reference from and instead want to reference the entry in Microsoft Lists instead. The code below almost works but it grabs the data from a different entry to the one I'm editing.
If(
SharePointForm1.Mode<> FormMode.New,
Collect(
colCategorydata,
LookUp('Name of Microsoft List', ID = SharePointIntegration.SelectedListItemID).'Name of choice column'
)
)
I feel like I'm close and hoping for some help with referencing the right ID.
Cheers,
Kieran
