Hi,
I have an editable grid that patches to a SharePoint list. As of right now, the add row button adds in 1 row at a time with some of the values already preset when the row is added. I have a column named "EventDays" in the parent sharepoint list and need the add row button to add x amount of rows based on the "EventDays" value. "EventDays" is a calculated column in the sharepoint list. So if the "EventDays" = 5 rows, the add row button should add 5 rows at once. I still want the ability for the rows to have the preset values there. Any help is appreciated!
here is my screen:
Add Row On Select:
Patch(
'Checklist Details',
Defaults('Checklist Details'),
{Title: Last('Event Information').ID},
{'Event Date': Last('Event Information'). 'Event Start Date'},
{'Event Zip': Last('Event Information'). 'Event Zip Code'},
{'NNAttendees': Last('Event Information'). 'NN Attendees'},
{'N Attendees': Last('Event Information').'N Attendees'}
);
Set(varReset,false);
Set(varReset,true);
ClearCollect(colPerDiemRate,Table1);
Gallery Items:
Sort(
Filter(
'Checklist Details',
varReset),
Modified,
SortOrder.Descending)
Save On Select:
Patch(
'Checklist Details',
ShowColumns(
colMealUpdates,
"Title",
"Event_x0020_Date",
"Event_x0020_Duration_x0020__x002",
"N_x002d_N_x0020_Attendees",
"N_x0020_Attendees",
"Per_x0020_Diem_x0020_Rate",
"Per_x0020_Diem_x0020_Total",
"Required_x0020_Meals",
"ID",
"Total_x0020_Attendees",
"Event_x0020_Zip"
)
);
Notify(
"Meal details have been updated successfully",
NotificationType.Success,
3000
);
Clear(colMealUpdates);
Set(varReset,false);
Set(varReset,true);
Navigate(TrackingScreen)
