I have a powerapps form which was working correctly two days ago and for some unknown reason has stopped bringing in the filtered table data.
1. The Depot field is a Choices field, once selected this then populates what is seen in the Employee ID field
2. EmployeeID is a ComboBox, and the formula is:
Sort(
Distinct(
Filter(Act_Driver_Count, Depot = DataCardValue123.Selected.Value),'Emp_#'),Result,Ascending)
3. This should then populate the Name of the Employee depending on the EmployeeID selected, formula:
Filter(Act_Driver_Count, 'Emp_#' = ComboBox3.Selected.Result)
As stated above this was working correctly for all records two days ago (11 January), and now it's only bringing back the data for 1 depot. I am hoping someone might be able to provide insight as to how to fix this or what may have happened.
Thanks


Report
All responses (
Answers (