Announcements
i want to compare my date from SPO list withe the current date
this is my function : div(sub(ticks(item()?['DateFinContratMat_x00e9_riels']),ticks(utcNow())),864000000000)
i don't now why dosent work any help ?
Simply add a Compose before the Condition to display the values that you want to compare.
Why do you use ticks()?
it dosent work @Chriddle
But the error message tells, that item()?['DateFinContratMat_x00e9_riels'] is null 😉
but my item is not null
But its property DateFinContratMat_x00e9_riels is (or it does not exist)!
DateFinContratMat_x00e9_riels is existed
This is not a real proof. Check the output of "Get Items" in the flow run.
Or remove the question mark from item()?['DateFinContratMat_x00e9_riels'].
The error message wll tell if this property exists.
Or put item()?['DateFinContratMat_x00e9_riels'] into the new Compose.
@Chriddle
Pls. put just the expression items('Apply_to_each') into the Compose.
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.
David_MA 282 Super User 2026 Season 2
trice602 159 Super User 2026 Season 2
11manish 146 Super User 2026 Season 2
