question

SerraChris-9253 avatar image
0 Votes"
SerraChris-9253 asked SerraChris-9253 answered

Combining two lists using lookup and existing column

Hello everyone. I have a powerapp that uses 2 lists as data sources. List 1 has a parts column and a vendorname column, and is about 500 rows long. List 2 has vendorname, address, contact# columns and is 29 rows long. I want to join these so list 1 pulls the contact info from list 2. The best way for me to explain this is by simulating a VLOOKUP in excel. That would be simple. I have tried using a LOOKUP in List 1, but I need to go back and in the lookup column choose the vendor name, even though it is in the column right next to it. Is there a way to use the existing vendorname column to join them together?

thank you!

Chris

office-sharepoint-online
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SerraChris-9253 "microsoft-graph-sites-lists" tag is for questions about SharePoint sites and lists API in Microsoft Graph. Per your description, your issue is not related MS Graph, we will remove the tag and add "office-sharepoint-online" to seek better help for you.
If I misunderstand your meaning, please feel free to reply. Thanks for your understanding and cooperation.

0 Votes 0 ·
YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered

Hi @SerraChris-9253
Per my test, currently there is no OOB method to use the existing vendorname column to join them together. As the format of vendorname column is different from lookup column, we could not change the vendorname column into lookup column.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SerraChris-9253 avatar image
0 Votes"
SerraChris-9253 answered

Thank you for clarifying!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.