I'm struggling with something that I thought would be relatively simple.
- I have a SharePoint list of Approved Campaigns.
- This list contains two date columns CampaignStartDate and CampaignEndDate
- These columns are both Date/Time columns and are set to only store Date
- I'm trying to create a gallery that filters the Approved Campaigns based on the start date being greater than or equal to 4/1/2021.
- In my screen's OnVisible property, I'm creating a collection like so:
ClearCollect(ColApprovedCampaigns, 'Approved Campaigns')
- I have confirmed that the collection is created successfully and that the CampaignStartDate and CampaignEndDate columns are present in the collection.
- In the gallery filter, I'm trying to filter the collection like so:
Filter(ColApprovedCampaigns, CampaignStartDate>=4/1/2021)
- It doesn't give me any errors, but it also does not filter my gallery, it just displays all of the records.
I've tried a number of things to resolve this, but can't figure it out. Hoping someone can shed some light! Any help is greatly appreciated!
