Using Lookup in Powerapps to search in different data source

[ManojAG]

Hi Team, I have two lists in sharepoint. I am new and looking for a lookup formula in Powerapp to add a third column in Destination table using Lookup function. I am not sure how to accomplish it.

Essentially: lookup EnclosureNum from destination list to source list, find the match in source list and get the corresponding value in URL column from source table to destination table. 

Source Table                          

Item Number	URL
ATT12345-00	http://test.pdf

Destination Table

EnclosureNum	Item Name
ATT12345-00	Test Name

Thanks

Manoj

[#2]

@ManojAG Try using formula in below format: 

ClearCollect(
	colDestinationData,
	AddColumns(
		DestinationListDataSource,
		"URL",
		LookUp(SourceListDataSource, 'Item Number' = DestinationListDataSource[@EnclosureNum], URL)
    )
)

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.