Forum Discussion
How to update a specific set of SharePoint list records after changing variables in Power Apps.
I have a timesheet app that captures start and end times. Within the associated SharePoint list, there are calculated fields. I have these fields included on the Power Apps form. The problem is that the calculated fields are not updating after the Patch action (updates or new saves). I tried the REFRESH action, but it is not refreshing the calculations. The only way I have found to view the updated calculations in the Power App is to filter the list to a different set of records, then back to the original. Once the filter returns to the original updated records, the new calculated results can be viewed. There has to be an easier way to do this.
1 Reply
Your title and the post itself don't seem to be referring to the same problem!
Power Apps doesn't really like SharePoint calculated columns, so I would always do the calculation in the Power App itself and patch the result to, for example, a number column in the SharePoint list and not rely on the calculation being done in SharePoint and passed back to the app, which, as you've seen, doesn't work very well.Rob
Los Gallardos
Microsoft Power Platform Community Super User
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
