Unanswered

filter browse gallery based on lookup field

(0) Share

Report

Posted on by batmanMon

202

Hi, I have 2 SharePoint lists. 1st one is a lookup list, it has two columns (Country, ID), 2nd one collects all the data. I record all the data from PowerApp to my 2nd (main list). In my edit screen I use something like that

LookUp(Country,ID = GalleryItem.CountryNameID)

Country (2nd list, lookup)

CountryNameID (1st list, main one)

It works perfect. However, I cannot make it work in the filter in BrowseGallery. I have tried something like that but it didnt work. Can anyone please advice what i did wrong 😞
Sort(Filter(allRecords, If(IsBlank(CountryFilter.Selected),true,CountryFilter.Selected in LookUp(Country,ID=ThisItem.CountryNameID,CountryName) ),
ID,
SortOrder.Descending)

"CountryFilterSelected" is the name of my combobox to filter the gallery

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Hi , @batmanMon
According to your description, you want to filter by the LookUp column.
This is my test sharePoint list :
This is my canvas app:
Combo box - Items: Country
Gallery -items:
Sort( Filter(allRecords, CountryNameID.Id in ForAll(CountryFilter.SelectedItems,{Id:ThisRecord.ID}) || IsEmpty(CountryFilter.SelectedItems) ),ID,SortOrder.Descending)

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. You could give me your sharepoint list sample data in your side .

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
batmanMon 202 on at

Like (0)

Report

@v-yueyun-msft works like a charm. Thank you!

Was this reply helpful? Yes No