// Collect data from Form1
Set(
Form1Data,
{
Title: DataCardValue21.Value,
IPDusers: ComboBox4.SelectedItems,
BOusers: ComboBox5.SelectedItems,
ADusers: ComboBox6.SelectedItems,
ComplianceUsers: ComboBox1.SelectedItems,
QAUsers: ComboBox2.SelectedItems,
CCDUsers: ComboBox3.SelectedItems
// Add other fields from Form1 here
}
);
// Collect data from Form2
Set(
Form2Data,
{
VendorName: DataCardValue11.Value,
EvaluationDate: DataCardValue12.SelectedDate,
EvaluationEndDate: DataCardValue1.SelectedDate
// Add other fields from Form2 here
}
);
// Combine both data sets
Set(
CombinedData,
{
Title: Form1Data.Title,
IPDusers: Form1Data.IPDusers,
BOusers: Form1Data.BOusers,
ADusers: Form1Data.ADusers,
ComplianceUsers: Form1Data.ComplianceUsers,
QAUsers: Form1Data.QAUsers,
CCDUsers: Form1Data.CCDUsers,
VendorName: Form2Data.VendorName,
EvaluationDate: Form2Data.EvaluationDate,
EvaluationEndDate: Form2Data.EvaluationEndDate
// Add any other fields that need to be combined
}
);
// Patch combined data to data source
Patch('DataSource', Defaults('DataSource'), CombinedData);
Concurrent(
SubmitForm(Form1),
SubmitForm(Form2),
SubmitForm(Form3)
);
MS.Ragavendar
10
LC-26081402-0
6
EE-04041031-0
4