Hello - looking for a solution.
We have a pretty basic time keeping app that we trying are to build. It uses Dataverse tables to collect time entries. It is not part of a solution, and it is setup to work offline using an offline profile. There are other screens with a Browse Gallery, a detail form, and a an edit form. These all work perfectly fine. Also should mention that almost all preview and experimental settings for the app are off. Just the few needed for taking the data offline are toggled on.
The time entry table has the entry date, and the number of hours on the entry date. On the start screen, I have a drop down that contains a limited range of week ending dates connected to a collection of start/ending dates for the weeks. Under the drop down is a row of text labels - one for each day of the week, and one for a total for the week. The formula for the text label (for a Wednesday in this example is:
Sum(Filter('Sitework Times',EntryDate = DateAdd(ddWeek.Selected.Starting,3,TimeUnit.Days)),Hours)
This works great when in the designer to show the user a summary of their time for the given week. When the app is published, however, the label text controls are blank. I have tried using the text input control, creating a collection using the same formulas that refreshes when the week changes, putting the formulas in the formulas property, using context variable, and using global variables. No matter what, I cannot get the text label controls to display the formula results in the published app (tested on iPhone and on Samsung Galaxy). All of the other functions work in the published app just as expected.
I have attached screenshot of the app in the designer and on the iPhone. What am I missing? I am guessing it is checkbox somewhere. Or maybe has to do with UTC time versus local time?