Need some help with this...
I have a ClearCollect called ccTest pulling information from a sharepoint list name called TEST and a column name CYCLEDATE (showing dates like 8/4/2022 or 8/11/2022 etc.
I have a filter on this gallery: Filter(ccTest,CYCLEDATE= Dropdown1.Selected.Result)
It will only show in (Gallery1) the results after you select from the dropdown (Dropdown1) certain date (8/4/2022 & etc.)
Now, on my next screen (Duplicated Screen)
Gallery1_1 still using the same results as above Filter(ccTest,CYCLEDATE= Dropdown1_1.Selected.Result) after selecting selected date from Dropdown1_1.
My issue is: I need to filter ccTest by using Dropdown1_1 for the 'CYCLEDATE' AND by another column name called 'Code' with these values (UK, NP, Q)
I tried using: Filter(ccTest,CYCLEDATE= Dropdown1_1.Selected.Result && Code="UK") it works but I need to be able to see all "UK, NP, Q" results after selecting the dropdown date. Is this possible to get the results for the 3 code names with filtering by date too?
Thank you
