Hi,
I have a Sharepoint list as a data source and Radio button inside Gallery2 (Gallery1.Selected).
I'm trying to Filter three dates inside Radio, so if 3 days left until Event Date 1, Event Date 2, Event Date 3 - they will hide:
Filter(
Table(
{EventDateTbl: ThisItem.'Event Date 1'},
{EventDateTbl: ThisItem.'Event Date 2'},
{EventDateTbl: ThisItem.'Event Date 3'}
),
DateDiff(Today(), EventDateTbl) > 3)
It works fine with simple rows, but not with more complicated rows:
Filter(
Table(
{EventDateTbl: ThisItem.'Event Date 1' & Text(" - ") & ThisItem.'Event End Date 1'},
{EventDateTbl: ThisItem.'Event Date 2' & Text(" - ") & ThisItem.'Event End Date 2'},
{EventDateTbl: ThisItem.'Event Date 3' & Text(" - ") & ThisItem.'Event End Date 3'}
),
DateDiff(Today(),EventDateTbl) > 3)
Here it will hide all dates, because DateDiff is comparing the whole row and not just ThisItem.'Event Date *' (make sense).
What is the correct way to "Filter" to get a result below?
Thanks in advance!
User | Count |
---|---|
125 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
216 | |
181 | |
140 | |
97 | |
83 |