You’re offline. This is a read only version of the page.
Announcements
43
Dear all,
I failing in a basic filter for a Gallery and after check a lot of tests I beeg your help:
I have a Gallery reaing data from a Sharepoint List named Ideas. This list is used in Items Gallery.
I have another Sharepoint List named Personas. In this I have the relation between a persona and the plant who belong.
When somebody enter in my App, I identify the plant belongs to and creating a variable with Set(_Planta_ID;LookUp(Personas;Mail=User().Email;Planta.Id)) and runs ok.
Then I want to filter the Gallery using the column "Created by" and searching in Personas the plant, so I could filter to _Planta_ID
My fail comes because I don't know how add the column Plant to the Gallery to be filtered.
Tested with Search, Filter...LookUp or creating collections...I've failed.
Any idea will be welcome!
If you still can't solve it, here's an idea.
You can join two lists like this. I'm using two example lists: Countries and Population.
Countries:
Population:
In my example, I created a collection:
Share
Report
All responses (
Answers (
ClearCollect(
ColCountries,
ShowColumns(
AddColumns(
Countries,
"Population",
LookUp(Population, CountryID = Countries[@ID], Population)
),
"Title",
"Population"
)
)
Result:
If you don't already know this List[@ID] part, the @ is called the disambiguation operator. Here more details.
If you want more ideas on how to join two or more tables, do a search like this.
