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

Like (0) Share

Report

Posted on 3 Aug 2023 22:34:56 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,513 Super User 2025 Season 2 on 04 Aug 2023 at 00:20:38

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!