Combining Data from 2 Sharepoint Lists with Matching Columns

(0) Share

Report

Posted on by 4wordsback

Hey All,

Hoping for Help.

I have 2 SharePoint lists:

I want to Have the Columns in Order history moved into the Columns in master item list.

Would prefer to do a bulk update.

Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @4wordsback

Can you try this?
ForAll( Filter( 'Order History', 'Monthly Units' > 0 ), Patch( 'Master Item List', LookUp( 'Master Item List', Item = Item ), { 'Last Ordered': 'Last Ordered', 'Monthly Units': 'Monthly Units' } ) )

Was this reply helpful? Yes No
BhaskarDhone 1,398 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
There is no direct join functions available in PowerApps but you can workaround this. Try with below logic

ClearCollect( collectionC, AddColumns( MasterItemList As masterListData, "LastOrdered", LookUp(OrderHistory, item = masterListData.item).LastOrdered, "MonthlyUnit", LookUp(OrderHistory, item = masterListData.item).MonthlyUnit ) )

Was this reply helpful? Yes No
4wordsback 46 on at

Like (0)

Report
Copy link

Link copied!

Sorry Neither options worked

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @4wordsback,

I think @DJ_Jamba 's direction is correct, however, we may need a fine-tuning for column reference if you have totally same columns in both lists.

ForAll( 'Order History' As Tem, Patch( 'Master Item List', LookUp( 'Master Item List', Item = Tem.Item ), { 'Last Ordered': Tem.'Last Ordered', 'Monthly Units': Tem.'Monthly Units' } ) )

Note that you must ensure that the Item column is the primary key in both lists so that we could map records in both.

Was this reply helpful? Yes No