Answered

Using a label to pull in info from second datasource

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I have a gallery that is tied to my data source and is working perfectly. I want to use one of the existing labels to pull in more info from a different datasource. For instance, I have a column called StoreNumber in both of my data sources, and I want to use that to pull in the Address from the 2nd datasource. Very much like a VLOOKUP function, but I dont know if the lookup function from PowerApps can do what I am trying to do.

Thanks for any help,

Chris

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

Are you looking for something like this?

LookUp(SecondDataSource,StoreNumber = Gallery.Selected.StoreNumber).Address

Or instead of the Gallery.Selected.StoreNumber you could use the label that shows it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thats perfect, thank you very much!!! Using the label worked for me.
Chris
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
You welcome 😄