Good morning all,
This is my first post so be gentle! I've only just started to learn powerapps and ive found lots of useful help on these forums, but im struggling to find anything to resolve this issue im having.
So i have a gallery of data which comes from a sharepoint list. I want users to be able to filter this data based on a number of Combo boxes and 2 date pickers (So, be able to filter the data between 2 dates selected from a date picker). I want the data to show everything in the first instance and then filter down depending on what is selected from the combo boxes.
I have come up with this formula for the combo boxes using just 2 of them as a start (i have about 6 i want to use in total);
As you can see there are no errors... But it doesnt work. The IsBlank works, because all the data is shown, but if i filter it no data is shown. the 'Audit Year' and the 'Status' are fields from my sharepoint list, i guess thats where im going wrong...
Also, i have a separate formula for the date pickers which i will need to integrate into the above formula, but that doesn't work either and im not sure why;
Again, the 'data' is from a sharepoint list.
Both formulas im using in the Items section of the gallery... Apologies, im very new at this! Its something very obvious im sure.
