cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phineas
Post Prodigy
Post Prodigy

Filter Field in Gallery

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
RobGas
Frequent Visitor

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

View solution in original post

3 REPLIES 3
RobGas
Frequent Visitor

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

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.

RobGas
Frequent Visitor

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?

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,171)