cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AB4N
Helper I
Helper I

Filter a list gallery with values from another list

Hi all,

 

I have one Gallery(ClientDataGallery) connected to a SharePoint list - Client Data

I have another SharePoint list - Client Attendance

 

Here is what I am trying to achieve: ClientDataGallery shows who should be clocked in today, and as people are clocked in on the Client Attendance list they are hidden from that gallery.

 

Both lists have a managed metadata column with the same name - Client Name (single selection only - can't add own values)

 

The ClientDataGallery has a filter that works great.

 

 

Filter('Client Data', Day.Value = DayLabel.Text && 'Workshop Attending'.Value = WorkshopDropdown.SelectedText.Value)

 

 

I want to add to this so that when people are clocked in on the Client Attendance list today, they do not appear on the ClientDataGallery

 

Any help would be greatly appreciated!

4 REPLIES 4
CNT
Super User
Super User

@AB4N 

Please try the following,

Filter('Client Data',
	Day.Value = DayLabel.Text &&
	'Workshop Attending'.Value = WorkshopDropdown.SelectedText.Value &&
	!('Client Name' in ShowColumns('Client Attendance', "Client Name"))
)

Hello, thank you for your reply.

Unfortunately, I receive a couple of errors:

 

!('Client Name' in ShowColumns('Client Attendance', "Client_x0020_Name"))

 

Client Name shows the error "Expecting a Record Value" & Your formula is missing a column  "Client_x0020_Name" with type Record.

 

Client_x0020_Name shows the error expecting a Table value, but of a different Schema & your formula is missing a column 'Label' with a type of 'Text'

@AB4N 

Please try the following,

!('Client_x0020_Name' in ShowColumns('Client Attendance', "Client_x0020_Name"))
AB4N
Helper I
Helper I

Still not working, unfortunately, I believe it is the managed metadata columns (Client Names) that are messing it up.

 

I have recreated both lists and galleries using a text column instead of a managed metadata column and created 3 Galleries, 1 for the first list, 1 for the second list, and 1 for the comparison and it works great, even with a different method:

Filter(Gallery1.AllItems, !(ClientNameA in Gallery2.AllItems.ClientNameB)).ClientNameA

 

We would prefer to have these columns as managed metadata, anyone have any ideas on how to make this work with managed metadata columns? 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,523)