Answered

filter browse gallery based on lookup field

(0) Share

Report

Posted on by batmanMon

199

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:

Using Apps Using Formulas

All responses (2)

Answers (1)

batmanMon 199 on at

Like (0)

Report

Re: filter browse gallery based on lookup field

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

v-yueyun-msft on at

Like (0)

Report

Re: filter browse gallery based on lookup field

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