I have this formula, that are been called inside 2 locations:-
//store the options to popualte the dropdowns based on the available data onky
ClearCollect(colOptionsForChoices,Filter('Work Orders',
('Work Order Status'.Value = "Assigned" Or 'Work Order Status'.Value="New") And
(Street = colSelectedStreetName Or IsBlank(colSelectedStreetName)) And
(Direction = colSelectedDirectionName Or IsBlank(colSelectedDirectionName)) And
('Location Name' = colSelectedLocationName Or IsBlank(colSelectedLocationName)) And
('Work Order Type'.Value = colSelectedTypeName Or IsBlank(colSelectedTypeName)) And
('Technician Name'.Email = colSelectedTechnicianName Or IsBlank(colSelectedTechnicianName) Or 'Work Order Type'.Value ="Posting"
Or 'Work Order Type'.Value ="UnPosting" Or 'Work Order Type'.Value ="Campaigns Photos" ) And
(Brand = colSelectedBrandName Or IsBlank(colSelectedBrandName)) And
('Work Order Status'.Value = colSelectedTStatusName Or IsBlank(colSelectedTStatusName))
));
1) Screen OnVisible
2) Clear button
currently i am adding the same formula twice, and when i want to modify it i need to do this twice. so i find a solution , where i can add a hidden button with this formula inside the button OnSelect() propert, and then I can call this button using Select(buttonname).. it worked for me, but not sure if this method is fine or it has drawbacks i am unaware of?
Thanks
