If you want to combine two SharePoint lists data and display the combined result within a gallery:
I have two SharePoint Lists: CustomerInfo and ProductInfo: In this scenario I will be comparing the Customer ID between two lists and getting the Price information on gallery.
I have created an app and added the Gallery control on the app:
Set the OnVisible property of your first screen of the app:
ClearCollect( CustColll, CustomerInfo ); ClearCollect( ProdColll, ProductInfo )
Set the Items property of the gallery control.:
AddColumns( CustColll, "tempPriceValue", LookUp( ProdColll, CustID = CustomerID, Price ) )
Here:
AddColumns: Function which will add the columns to table.
CustColl: Is the collection variable which I created above.
tempPriceValue: Above formula will add this column to result.
Finally, insert the label into gallery and update the Text property as below:
ThisItem.tempPriceValue
No comments:
Post a Comment