Help please and thank you, i am tryin to collect all selected data using a button to submit to a excel sheet.
refer code below, not sure how to get pass this. The app is being created from scratch with not using any external data, i also havent used any forms or galleries, and not sure if that is required to allow me to export data
ClearCollect(PSIQuestion,
{
Date:DatePicker1.SelectedDate, Warehouse: Warehouse.Selected.Value,
Name: Name.Selected.Value,
'What Wasnt as Safe': Wasntsafe.Text,
'What was More safe': Moresafely.Text,
'Safety Performance': ListBox1.SelectedItems,
'Coretask':DDCoreTask.Selected.Value,
'Critical risks': CBCriticalrisk.SelectedItems.Value, 'Critical Controls': CBCriticalcontrols.SelectedItems.Value,
'Risk for Task': CBRisks.SelectedItems.Value,
'Risk Controls': CBControlsRisks.SelectedItems.Value })

