Gallery two data sources need to connect the drop down with the second data source to data source one

(0) Share

Report

Posted on by mjackson122

I have a gallery with Data source A and various this item fields relevant to DataSourceA. I have specific dropdown field in the gallery called Initials and it displays only initials as the drop down items. DataSourceB has two columns initials (which matches DatasourceA) and name which is the defined name of initials. I am attempting to add DatasourceB Name column to the gallery and have that as the drop down. But I cannot get the logic so the existing gallery items will populate with the full name.

DataSOurceA Intials

Data SourceB

Initials Name

N Nancy

E Easton

W West

Goal is everywhere in DataSource A that has N display Nancy from DataSourceB. Then for every new item added display Name in the drop down.

All responses (1)

Answers (0)

narayan225 2,449 Super User 2025 Season 1 on at

Like (0)

Report
Re: Gallery two data sources need to connect the drop down with the second data source to data source one

@mjackson122

I am not sure how your power app is setup but you can use lookup to achieve that.
LookUp(DataSourceB, Initials = DataSourceA.Initials).Name
It would be easier if you could show your gallery and dropdown setup.

Cheers!