Hello everyone,
I have been struggling with one combo box issue when I use Add columns function and create a new column in the combo box "items" property. Afer submit my list has no value for the column "Project"(lookup column of another list) in a list,
I have a list "Task", in which I have used a Lookup column from another list "Project".
List Task example -
ID Project TaskDescription
1 PRJ001 Add a combo box
2 PRJ002 Add a table for showing leave data
List "Projects" example -
ID Projectcode CompanyName
1 PRJ001 QAIB
2 PRJ002 NASD
I am using the below code to insert it into the "Task" list
Set(
isSubmitClicked,
true
);
If(
fTaskMain.Valid,
SubmitForm(fTaskMain);
Set(
LastInsertedTask,
fTaskMain.LastSubmit
);
RemoveIf(
TaskLogDetail,
TaskNo = Value(txtID.Text)
);
ForAll(
UserLog,
Patch(
TaskLogDetail,
Defaults(TaskLogDetail),
{
Comment: Comment,
Time: Value(Time),
Date: Date,
TaskNo: Value(LastInsertedTask.ID),
User: User
}
)
);
If(
Not(IsBlank(LastInsertedTask.ID)),
Notify(
"Saved Successfully !!.",
NotificationType.Success,
7
);
Clear(UserLog);
ResetForm(fTaskMain);
ResetForm(fLogDetail);
Set(
isSubmitClicked,
false
),
Notify(
"Some error occurred. Not able to save !!",
NotificationType.Warning,
7
)
);
,
Notify(
"Mandatory fields can not be blank.",
NotificationType.Error,
7
)
);
