Hi @Anonymous ,
Do you want to submit 7 items into your second List ('Resource Available Hours') once your "Resource Details" form has been submitted successfully?
Based on the needs that you mentioned, I think the "Repeating Table" functionality using Gallery could achieve your needs. On your side, you could consider configure your Gallery as a "Repeating Table" with 7 items/rows.
Please check and see if the following video could help in your scenario:
https://www.youtube.com/watch?v=xgznk4XlPCo&t=33s
https://www.youtube.com/watch?v=DylxsXIUyDc&t=8s
https://www.youtube.com/watch?v=HUX_0AA4-Hs&t=1s
On your side, you could consider configure your Gallery as below:
Set the OnStart property of the App to following:
ClearCollect(
TemporaryCollection,
Defaults('Resource Available Hours List'),
Defaults('Resource Available Hours List'),
Defaults('Resource Available Hours List'),
Defaults('Resource Available Hours List'),
Defaults('Resource Available Hours List'),
Defaults('Resource Available Hours List'),
Defaults('Resource Available Hours List')
);
ForAll(
TemporaryCollection,
Collect(
NewEntryCollection,
{
Index: CountRows(NewEntryCollection),
'Employee ID': TemporaryCollection[@'Employee ID'],
Date: TemporaryCollection[@Date],
'Available Hours': TemporaryCollection[@'Available Hours'],
'Chargeable Hours': TemporaryCollection[@'Chargeable Hours']，
Duration: TemporaryCollection[@Duration],
Comments: TemporaryCollection[@Comments],
'Deviation Hours': TemporaryCollection[@'Deviation Hours']
}
)
)
Set the Items property of the Gallery to following:
If(
EditForm1.Mode = FormMode.Edit,
Filter('Resource Available Hours List', 'Employee ID' = BrowseGallery1.Selected.'Employee ID'), // BrowserGallery1 represents the Gallery in your app to list all "Resource Details" records
NewEntryCollection
)
Within the Gallery, set the DefaultDate property of the DatePicker control to following:
If(
!IsBlank(ThisItem.Date),
ThisItem.Date,
DateAdd(StartDatePicker.SelectdDate, Index)
)
Set the OnSuccess property of your Edit form (connected to your "Resource Details" List) to following:
If(
IsBlank(
LookUp('Resource Available Hours', 'Employee ID' = EditForm1.LastSubmit.'Employee ID')
),
ForAll( // Add 7 new items into your second list
RepeatingTableGallery.AllItems,
Patch(
'Resource Available Hours',
Defaults('Resource Available Hours'),
{
Date: DatePickerInRepeatingTable.SelectedDate,
'Available Hours': AvailableHoursTextInputBox.Text,
'Chargeable Hours': ChargeableHoursTextInputBox.Text,
Duration: DurationDropdownBox.Selected,
Comments: CommentsTextInputBox.Text,
'Deviation Hours': DeviationHoursTextInputBox.Text
}
)
),
ForAll( // edit existing 7 items related to current Employee Id in your seocnd List
RepeatingTableGallery.AllItems,
Patch(
'Resource Available Hours',
LookUp('Resource Available Hours', 'Employee ID'= EditForm1.LastSubmit.'Employee ID' && Date = DatePickerInRepeatingTable.SelectedDate),
{
Date: DatePickerInRepeatingTable.SelectedDate,
'Available Hours': AvailableHoursTextInputBox.Text,
'Chargeable Hours': ChargeableHoursTextInputBox.Text,
Duration: DurationDropdownBox.Selected,
Comments: CommentsTextInputBox.Text,
'Deviation Hours': DeviationHoursTextInputBox.Text
}
)
)
)
Please take a try with above solution, then check if the issue is solved.
Best regards,
