Announcements
Hello everybody;
how to fix delegation problem in this expression:
Filter(Visit; ThisItem.Id = Month(DateVisiteStart))
Knowing that Id takes values from 1 to 12.
Hi @gikido
You don't share what the delegation warning is so I have to guess.
Change your filter
Instead of using Month(DateVisiteStart) which is not delegatable
create an int variable that has the value, and assign the value instead of the Month expression.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help othersCheersThank YouMichael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsofthttps://gernaeysoftware.comLinkedIn: https://www.linkedin.com/in/michaelgernaey
Hi @gikido,
Have you solved your problem?
If you have less than 2000 records, please ignore the delegation warning message and try to use With():
With({DateVisiteStart:<your_formula_for_DateVisiteStart>},Filter(Visit; ThisItem.Id = Month(DateVisiteStart)))
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 409 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 252 Most Valuable Professional