Answered

Filter Field in Gallery

(0) Share

Report

Posted on by Phineas

5,331 Moderator

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RobGas 75 on at

Like (0)

Report
Copy link

Link copied!

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')

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RobGas 75 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No