Compare date with other dates in same column in gallery to see if they match between years

(0) Share

Report

Posted on by evalindag

117

Hi everybody

I'm wondering if there is any way to compare a date with other dates which are in the same column within a gallery to check whether there is a record for the same dates in the previous year.

I've uploaded a screenshot, so what I would like to be able to do is compare these from and to dates to other records in the data source to see if there was an record during these days in the year before. As you can see, the column "Last Year" for the second line should be "Test2" to show that during these dates last year a group named "Test2" had booked these dates.

I hope I've explained the scenario good enough and I would really appreciate if someone could help me with this.

Best regards

Eva

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@evalindag
Please insert a new label into your gallery with this code in the Text property. It will show true when there is a match and false when there is no match.

LookUp( your_datasource_name, FromDate=DateAdd(ThisItem, -1, Years), And ToDate=DateAdd(ThisItem, -1, Years) )=Blank()

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
evalindag 117 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much @mdevaney your solution worked perfectly!

Best regards
Eva

Was this reply helpful? Yes No