Announcements
Hi Guys,
Looking to filter the Gallery so it is not equal to Assigned to, the app shows all outstanding items that have not been assigned.
J
Are you looking to return all items that don't have an Assigned To and is the Assigned To a people field?
@Jeff_Thorpe
Yes and yes.
Here is an example. You will need to change the data source and column names.
Fliter(DateSourceName, PersonColumnName.DisplayName = Blank())
The Person Column Name is that the List name, if it is then the formula throws up that it isn't a valid name when it is.
@jbrines , are you saying that the list has the exact same name as the people column in the list? In my example the DataSourceName should be replaced the ListName and the PersonColumnName should be replaced by the people column name in the list. If the list and column have the same name I guess the formula editor could get confused on which object it is working on. In general if you just start typing in the formula editor box it will suggest the correct one for you.
@Jeff_Thorpe The formula you gave doesn't like my column name, it says the Name is invalid.
Date Source Name - 'Client Issue'
Person Column Name - 'Assignto'
So I put the formula as
Fliter('Client Issue', 'Assignto'.DisplayName = Blank())
I get the following error.
Aside from flittering instead of filtering!
@Drrickryp thanks
and @Jeff_Thorpe helps if I can add the correct column name 🙂
H
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 207 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2
