Variable not updating onvisible of Screen

[Anonymous]

On App Start I have a list of new hires for a Manager. When they click on one of the new hires I have the OnSelect = Set(varNHName, NewHires.Selected.Newhirename ) ; Navigate(Tasks)
 
On the Tasks Screen, the Gallery items are filtered using this formula: SortByColumns( Filter( managertasks, Newhirename = varNHName),"TaskOrder",Ascending)

What I am trying to do is that when that screen loads, capture how many tasks are associated for the new hire, and how many have a Status = Completed. Then, using those variables, display a progress indicator of percent complete.

My "guess"  is that the filtering of the gallery is causing an issues setting the variables, but not sure how to resolve..

I've tried multiple options for the OnVisible setting for the Tasks Screen, which all resulting with the same issue.. The variables don't update until I click a Task and then return to the Task list.

The OnVisible formulas I've tried are below:
UpdateContext({AllRows:TasksGallery});
//Set(NumberOfCompletedTasks, CountRows(Filter(AllRows.AllItems,TaskStatusVal.Text = "Completed")));
//Set(NumberOfTasks, CountRows(AllRows.AllItems));
UpdateContext( {NumberOfCompletedTasks: CountRows(Filter(TasksGallery.AllItems,TaskStatusVal.Text = "Completed"))} );
UpdateContext( {NumberOfTasks: CountRows(TasksGallery.AllItems) } );
//Set(NumberOfCompletedTasks, CountRows(Filter(TasksGallery.AllItems,TaskStatusVal.Text = "Completed")));
//Set(NumberOfTasks, CountRows(TasksGallery.AllItems))

With any of those when I first start the app and click on a new hire name, the variables come back with Zero( labels added to check) and progress bar is also at Zero:

If I click on a Task for that new hire and then return to the Task list by clicking the Cancel button( Navigate back to Tasks screen): Then the Variables update and the Progress indicator also works:

If I click the "Return to new hires list button ( navigate to main screen), and click on a different new hire, the previous variables are "stuck" until I click on a task for that person. Only 2 items are set as completed for this user:

and again, if I click on a task for that user and return to the Task list, the variables are correct.

Is it my Filter for my gallery causing the issue, and if so how do I "delay" the variables to update once the filter is complete?

[PriyankaGeethik]

Hi @Anonymous ,

I would suggest. Instead of gallery if you try with the collection or DataSource binded with the gallery for countrows it might help. 

Set(NumberOfTasks, CountRows(Filter( DataSourceName,YourStatusColumnName= "Completed").ID));

 Below code you can put onvisible of the Screen.  

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous · Accepted solution]

@PriyankaGeethik  Thanks for the suggestion!! 

I ended up creating a collection as part of the Navigate button from the first screen:

Set(varNHName, NewHires.Selected.Newhirename ) ; ClearCollect(ColManTasks, Filter( managertasks, Newhirename = varNHName) ) ; Navigate(Tasks)

Then, for the OnVisible setting, I created my counts based off that Collection, rather then the filtered gallery:

UpdateContext( {NumberOfCompletedTasks: CountRows(Filter(ColManTasks, 'Task Status'.Value = "Completed"))} );
UpdateContext( {NumberOfTasks: CountRows(ColManTasks) } );

and now the Progress indicator and the counts change whenever the task list is shown!

Thanks again for the idea!!