Gallery with Filter from 2 SharePointlists

(0) Share

Report

Posted on by Peter_Sch

Dear All,

I have a Question about a Gallery Filter:

Following Szenario:

2 Sharepoint Lists:

Travel	Seatrequests
ID	ID
departureTime	TravelID
returnTime	Requester
Owner

Employees can Create a travel and offer seats for other colleagues. The TravelID in Seatrequests is the Value of the ID from the associated Travel.

I have a Gallery where all my Seatrequests are shown with a Simple Filter: Filter(Seatrequests,Requester.Email = currentUser.Email)

Problem: It shows also requests from the Past because the departureTime is in an other SharepointList (Travel) and this makes it not possible to Filter it easily for me. I think I have to use a Lookup or someting to merch the ID with TravelID to get the depatruretime > now().

Filter( Seatrequests, Requester.Email = currentUser.Email && LookUp(Travel, ID = TravelID, departureTime > now())) shows me nothing. Has anyone an Idea how I can format the Filter? Many Thanks, Peter

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Peter_Sch

Try this formula,

Filter(
Seatrequests,
Requester.Email = currentUser.Email &&
Lookup(
Travel,
ID = Seatrequests.TravelID,
departureTime
) > Now()
)

(Or)

Filter(
Seatrequests,
Requester.Email = currentUser.Email &&
LookUp(
Travel,
ID = Seatrequests.TravelID && departureTime > Now()
) <> Blank()
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
Peter_Sch 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your Time,

the first one tells me Lookup is an unknown or unsupported funktion.

the second one tell me he cant compare ID = Seatrequests.TravelID because ID is a number and Seatrequests.TravelID is a table. And <> cant be compared be cause of types Record,objnull.
Verified answer

Peter_Sch 18 on at

Like
a
(0)

Report
Copy link

Link copied!
I got the Solution. Sometimes it just need a sleep and more Coffee 🙂

Filter(Seatrequests, TravelID in Filter(Travel, ID && currentUser.Email = User().Email && departureTime > Now()).ID)