Calculated field is not updated in SharePoint list - only when manually changed

(0) Share

Report

Posted on by AlexJohn

Hello everybody,

I created an app where users input a date field (Startzeit). The entries are sorted by calendar week. The field for calendar week is called "KWNummer".

I have this formula in my app for this field "KWNummer":

If(IsBlank(ThisItem.Startzeit);ISOWeekNum(Today());ISOWeekNum(ThisItem.Startzeit))

If it is a new entry and Startzeit is blank, then the current calendarweek is selected. For new entries, the calenderweek is correctly written to the SharePoint list.

If a user made a mistake and changes the time (Startzeit) to a different calendarweek, the value is not updated in the SharePoint list though, altough the field in PowerApps show the correct value. The calendar week is supposed to be always calculated from Startzeit and updated and written to the SharePoint list.

I currently have no idea why it doesn't work when the Startzeit is changed.

Any ideas are appriciated!

Categories:

Building Power Apps

I have the same question (0)