Hi All,
Requesting help on below:
Getting user inputs for below fields and inserting into excel.
Manager,Team and Names are dependent dropdowns
Used below code :
// Check if a record with the same Name and Date already exists
Set(
existingRecords,
Filter(
Table1,
Name = 'ComboBox1_4 name'.Selected.Value &&
Date = DatePicker1.SelectedDate
)
);
If(
CountRows(existingRecords) > 0,
// Get the name of the existing record
Set(
existingRecordName,
First(existingRecords).Name
);
Notify("A record with the same Name and Date already exists for " & existingRecordName, NotificationType.Error),
// If no existing record found, add a new record
ForAll(
'ComboBox1_4 name'.SelectedItems As C,
Patch(
Table1,
Defaults(Table1),
{
Manager: 'Dropdown1_4 -mng'.Selected.Value,
Team: 'Dropdown2_4- team'.Selected.Value,
Name: C.Value,
Date: DatePicker1.SelectedDate,
Hours: TextInput1.Text,
Leave: 'Dropdown4-leave'.Selected.Value
}
)
);
Navigate(DataTable1)
)
Now my requirement is to choose a date range : - To select multiple date values with remaining field values in separate rows.
Got to know it could be achieved by using 2 date pickers (start and end) ,requesting help in modifying above with date range.
Any help in implementation steps would be highly appreciable !!!
