Gallery calculated field update only happens on collection change after refresh?

(0) Share

Report

Posted on by BrianHFASPS

732

My data is stored in SQL so I have to do the workarounds for time.

I have a gallery that has a calculated label in it with this code

Text(Now() - First(ForAll(MatchAll(Text(ThisItem.MorningSigninTime),"PT(?:(?<hours>\d+)H)?(?:(?<minutes>\d+)M)?(?:(?<seconds>\d+)S)?"),Time(Value(hours),Value(minutes),Value(seconds)))).Value, "hh:mm")

The gallery items are

Sort(
 Search(
 Filter(
 Filter(
 '[dbo].[Today Activity Attendance]',
 'Grade Sort' < 0
 ),
 Not(IsBlank(MorningSigninTime)),
 IsBlank(SignoutTime)
 ),
 'Active Student Search'.Text,
 "NoAccentFirst",
 "NoAccentLast"
 ),
 MorningSigninTime,
 SortOrder.Ascending
)

Then I have a timer for every 10 seconds that OnTimerEnd is

Refresh('[dbo].[Today Activity Attendance]');Refresh('[dbo].[Today Activity Attendance Signed Out]')

The calculated time field only appears to update (recalculate) when the collection changes. It does not update on every refresh. Not sure how else I can force a refresh?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Shaheer Ahmad 2,194 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Instead of relying on the automatic refresh of calculated fields, you can directly reference the SQL data in your formula. Ensure that the data retrieved from SQL is correct and up-to-date. For example:
Text( Now() - First( ForAll( MatchAll( Text( LookUp( '[dbo].[Today Activity Attendance]', ID = ThisItem.ID ).MorningSigninTime ), "PT(?:(?<hours>\d+)H)?(?:(?<minutes>\d+)M)?(?:(?<seconds>\d+)S)?" ), Time(Value(hours), Value(minutes), Value(seconds)) ) ).Value, "hh:mm" )

Instead of just refreshing the data source, try refreshing the entire gallery or the specific item in the gallery. For example:
Reset(Gallery1); // Replace Gallery1 with the actual name of your gallery

Let me know if this helps
BrianHFASPS 732 on at

Like
a
(0)

Report
Copy link

Link copied!

The SQL data isn't changing, it is recorded once a day. Even with the reset gallery it is only changing when the list in gallery changes.