web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Look up data from anot...

Power Apps

Answered

Look up data from another table

(0) Share

Report

Report

Posted on by Cjohnson20

31

I currently have a gallery that is set up to pull data on a project from a sharepoint list. Not all fields that I would like to display in this gallery are a part of the data source list, but are a part of another which both share a common ID filed. What would the syntax of a lookup function be to get the value I need based of the shared ID from both lists. This is what I currently have.

LookUp(Newtable,NewtableID0 = ThisItem.gallerysourcetableID,Title)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Cjohnson20

AddColumns( splist,"othertitle",LookUp( Newtable,NewtableID0 = splist,ID ).Title )
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Cjohnson20,

Have your solved your problem?

If you want to display items sharing the same id from another list, the formula you provided is correct, what's your problem?

LookUp( ListA,//This is my another list ID = ThisItem.ID,//This is the sharing id Stock//This is the needed displaying field from another list )

Join the conversation