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

(0) Share

Report

Posted on by Community Power Pla...

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...

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report

You should have 'varBookId' = ID

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It works ^-^ thanks ❤️

Was this reply helpful? Yes No