How do I use a sharepoint lookup colum in Filter Query on Power Flows?

[KitchenKirby]

I have two sharepoints list :

Books            Reservation

-ID                 -ReservationDate

-Name           -ReturnDate

                      -Book (LookUp of Books, showing the ID)

I have a flow "Get Items" that return the first value when there is a reservation between the specified dates, and if the book Id is equal to the ID. But I'm unable to compare a text value with a "LookUp" value, it always return false.

Note: The "List Name" is Reservation

Here is what my "Filter Query" looks like :

'varReturn' gt ReturnDate and 'varReservation' le ReturnDate and 'varBookId' eq Book

Except for the 'varBookId' eq Book, everything is working fine...

[grantjenkins]

You should have 'varBookId' = ID

[KitchenKirby]

If I do it, It will compare my varBookID with my Reservation ID sadly :c

[grantjenkins · Accepted solution]

Ah, sorry didn't catch the part with it being a Lookup column. Can you try Book/Id and see if that works.

[KitchenKirby]

It works ^-^ thanks ❤️