I see half dozen topics or more on this, but no solution has worked for me and I cannot figure out why. I have a sharepoint list with some users and Term_Date, which may or may not have any dates in it. I have a powerapp with a gallery connected to this list, and I'm trying to get users that are actively employed (no term date) or have been termed in the past 90 days.
Filter(MRL,Manager.Email = varUserEmail, Term_Date > DateAdd(Today(),-90) || IsBlank(Term_Date))
with this I see users that have term dates entered which are more recent than 90 days prior to today, but I don't see the blank users. If I take off the or (||) and isblank portion, there are absolutely no changes to my returned results. I've similarly tried Value(Term_Date)=0 and even IsBlank(Value(Term_Date) to no avail. I've tried with or without the table before (e.g. MRL.Term_Date) but no difference other than occasionally breaking the formula entirely. In trying to troubleshoot I created a label with the text ofIsBlank(Value(RecordsGallery.Selected.Term_Date)) and that seems to work- clicking on users in the unfiltered gallery updates the label and I see true or false, and it lines up with if I'd expect them to show up on my filtered gallery. But adding the logic to the gallery items selected filter itself always results in nothing.
The column settings in Sharepoint are Type Date and time with Include Time Off, Friendly format No, default value None, no calculated value and no requirements/enforce unique values/validation.
