Validation for time management sheet

(0) Share

Report

Posted on by RyoIshi731

238

Hello, I would like to ask do validation in time management sheet.

In below picture, this user is working 9:00-10:00 for 2 projects. Therefore I would like to validate when user push save button in second row.

The detail is like this.

-This gallery data source is correction.

-Once user push Save button, the data is saved in correction.

-The time for start and end is just dropdown

- When user push + button the row will be added.

- Onselect status of save button is like this.

Patch(
 DetailCol,
 ThisItem,
 {
 WorkingDay: WorkingDay.SelectedDate,
 ProjectName:ProjectName.SelectedText,
 Stuff:currentUser,
 WorkingHourFrom: Value(WorkingHourFrom.SelectedText.Value),
 WorkingMinuteFrom: Value(WorkingMinuteFrom.SelectedText.Value),
 WorkingHourTo: Value(WorkingHourTo.SelectedText.Value),
 WorkingMinuteTo: Value(WorkingMinuteTo.SelectedText.Value), 
 Note: Note.Text,
 saveBtn: false
 }
);

Categories:

Building Power Apps

I have the same question (0)