Answered

Filter Field in Gallery

(0) Share

Report

Posted on by Phineas

4,702 Super User 2025 Season 1

I have a Gallery displaying data from Collection1 (SharePointList1).

I've added additional Labels and Text Inputs (including 'PositionType') to the Gallery in which I need to display related data from a different data source (SharePointList2).

I've written the following, which is returning data from the first item in SharePointList2.

LookUp(Collection1,UserNameFld.Text = User().FullName).PositionType

Looks like I'm connected to the right source, I just need it to return the correct data.

Returned data should be where UserNameFld.Text = User().FullName.

Meaning, the field should auto-populate the 'PositionType' of the logged in User.

Categories:

General Questions

All responses (3)

Answers (1)

RobGas 75 on at

Like (0)

Report

Re: Filter Field in Gallery

You can always try to hardcode the ThisItem.FullName to something that exists in the list to see what it brings back, if it brings back the correct information it means that part of the formula is wrong, if not there's a different issue at hand.
Can you provide some screenshots of the List column names and the gallery itself?
Phineas 4,702 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter Field in Gallery

I tried both the below.

LookUp(SPList2, UserNameFld.Text = User().FullName,Title) - my version

LookUp(SPList2, FullName = ThisItem.FullName,Title) - your version

Both returned data from the first line item of SPList2. The right list just wrong item. Also, both kicked back delegation warnings.

BTW, the SPList2 'FullName' is a 'calculated' column in SharePoint - which may be causing its own problems.
Verified answer

RobGas 75 on at

Like (0)

Report

Re: Filter Field in Gallery

Hi Phineas, is it possible that you provide some screenshots of what you're trying to do?
From what I understood in your description is that you're trying to return a value from "Sharepointlist2" in gallery which displays items from "Sharepointlist1" based on the username?

The formula would look like this LookUp(SharePointList2, "insert column name from SharePointList2" = "Insert column name that shares the same values in SharePointList1", 'PositionType')

So for example LookUp(SharePointList2, FullName = ThisItem.FullName, 'PositionType')