Using Lookup in Powerapps to search in different data source

New Contributor

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 NumberURL
ATT12345-00http://test.pdf

Destination Table

EnclosureNumItem Name
ATT12345-00Test Name

 

Thanks

Manoj

1 Reply

@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.