cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to join 2 data sources and display in a text or label.

I have read the other posts but they add column. What I am trying to do is join two SharePoint lists (2 data source in power app lingo) and disply on a "Detail screen".

_________________________________________

Table one:

-----------------------------------------------------------------

Field1:BW Tools Number  |  Field2: Unit | Filed3: Date Created

 

___________________________________

Table two:

----------------------------------------------------------

Field1: BW Tools Number | Field2: Person Created | Field 3: Out of Service

*******************************************************************************************************************

I have added a text input box and added "LookUp(Table One,ID=BW_x0020_Tools_x0020_Number,Unit)" but when I run application, nothing shows up in the text box. Hence, I tried with a label but the the result, no go.

 

FYI: - On the detail screen , I have added/used table 2 as a data source.

What do I have to change in the lookup.

2 REPLIES 2
Jeff_Thorpe
Super User
Super User

I am not sure what your actual table and field names are but try something like this but replace the table and field names with the actuals names. This assumes that Field1 in each table are the keys.

 

LookUp(Table1, Field1 = Table2.Field1 ,Unit)



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Anonymous
Not applicable

Thanks Jeff,

I will try it out. Sorry for thte belated reply as I was away.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (55,116)