Power Platform Community Forum Thread Details

Hi,

have an app with multiple screens that is kind of based on few SharePoint list and with PowerApps i just customized one of those and connected to other as well.

All together i am connected to 6 lists and one MS 365 users connector.

One screen has a gallery that looks inside one of these SPO lists. Gallery items is:

Filter(tna,UPN=upn_label_5.Text, YearMonth=Dropdown_month.SelectedText.Result)

upn - text field
upn_label_5.text: label with

Microsoft365Users.MyProfileV2().userPrincipalName

yearmonth - number
Dropdown_month - dropdown that looks again into tna lists and offers user items where his upn is used....:

Distinct(Filter(tna,MonthlyApproval="Open",UPN=upn_label_5.Text).YearMonth,YearMonth).Result

Submit happens following

// save request to AR
Patch(
 'Absence Request',
 Defaults('Absence Request'),
 {
 TypeOfRequest: "TimeSheet",
 TimeSheetPeriod:Dropdown_month.SelectedText.Value,
 UPN: upn_label_5.Text,
 ApprovalStatus:"Pending",
 DaysInOffice: Value(sum_days_office_value.Text),
 DaysInHomeOffice: Value(sum_days_homeoffice_value.Text),
 DaysOnBT:Value(sum_days_biztrip_value.Text),
 RequiredTime: Value(totalreqtime_value.Text),
 YourTime: Value(totalyourtime_value.Text)
 }
);

// save values to tna and change the column monthlyapproval from OPEN to PENDING
ForAll(Gallery3.AllItems,
 UpdateIf(
 tna, ID = Value(idvalue.Text),
 {StartTime:from.Text, EndTime: to.Text, TimeAtWork: Value(hoursworked.Text), BreakInHours: Value(break.Text) , PassiveTravelTimeStart: pttstart.Text, PassiveTravelTimeEnd:pttend.Text, PassiveTravelTimeDurringWorkTime: pttdw.Text, MonthlyApproval: "Pending"}
 )
);

the manager then receives an email and can approve or reject (ms flow). the odd thing that happens is that once i submit it to manager the column ApprovalStatus should change to Pending - works fine what however sometimes happens is that random items are changed in the column BreakInHours... they are changed from whatever to 0. the column is a number column and has no default value... i have no idea where... and the code above also does not suggest to change it, as far i can see. below is a picture of SPO list and versioning...