Gallery items where the filter source is a different list

(0) Share

Report

Posted on by tuhriel

Hi,

I'm planning to do an simple event manager for a reccuring event and one part of it is the session backlog.

The data is located in two different sp lists: 'EMT.Sessions' and 'events'

One column 'EDD' within 'EMT.Session' looks up the data from the 'events' list.

The 'events' list has a colum (type choice) with the state of the event (planned, open for registration, done)

What I want to do now is to create a Gallery where it only shows sessions which are assigned to events that are not in the status 'done', but I really can't get my head around the syntax and the expected format.

At the moment the Items value of the Gallery has the following formula:

SortByColumns(Filter('EMT.Session', StartsWith(Title, TextSearchBox1.Text),EDD.Value = "2018-2"), "Title", If(SortDescending1, Descending, Ascending))

for what I plan to do the "2019-2" after EDD.Value should be replaced with something like this:

lookup(events, status != 'done')

But I can't get it to work as it always rejects either the operator and/or the returned result as wrong

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
You're looking for something along the lines of the expression below:

SortByColumns( Filter( 'EMT.Session', StartsWith(Title, TextSearchBox1.Text), EDD.Id in Filter(events, status <> "done").ID), "Title", If(SortDescending1, Descending, Ascending))

The idea is to take the ID property of all events with status different than 'done', then filter the sessions list where the id of the lookup column is in the ids you found before.
Verified answer

tuhriel 19 on at

Like
a
(0)

Report
Copy link

Link copied!
Okay that makes sense. There was still an argument missmatch, but I could figure that out:

SortByColumns( Filter( 'EMT.Session', StartsWith(Title, TextSearchBox1.Text), EDD.Id in Filter(events, status.Value <> "done").ID), "Title", If(SortDescending1, Descending, Ascending))
Thanks a lot