Announcements
@And(greaterOrEquals(item()?['EventDate'], addDays(utcNow(), -329)),lessOrEquals(item()?['EventDate'], addDays(utcNow(), -300)))
How can I turn this into a Function to filter by in my get items?
Hi @3cdoug ,Try placing below formula in Items property of Gallery control -
Filter(SPListName, EventDate >= DateAdd(Today(),-329,TimeUnit.Days) && EventDate <= DateAdd(Today(),-300,TimeUnit.Days))
I will try that, but I meant more so in the filter query. As part of the addDays function so that my filter query for my get items
Hi @3cdoug ,I thought that you have to use this formula in Power Apps.Try using below in Power Automate -
(DateCompleted ge addDays(utcNow(), -329)) and (DateCompleted le addDays(utcNow(), -300))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 1,045
Valantis 675
11manish 592
