Answered

Multiple Data Sources Combined Into One Dropdown List

(0) Share

Report

Posted on by kristinegriba

158

I think this can be done with collections but I need some guidance. Using two SharePoint lists, I'm looking to combine the data to create one dropdown list in my app that I am building in PowerApps.

In the first SharePoint list, "LIST_boys" I want to use the column "namesBoy" to combine it with the column, "namesGirl" in the second SharePoint list, "LIST_girls"

So taking from:

I want the resulting dropdown in my app in PowerApps to display:

Is this possible?

Thanks in advance to anyone who can put me on the right path!

Cheers,

Kristine

P.S. I am not entirely sure if I am in the correct user forum... I'm looking for assistance with PowerApps.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

jrletner 720 Super User 2025 Season 2 on at

Like (3)

Report

You could achieve this by building a collection from your datasources like this:

ClearCollect(
colCombinedNames,
RenameColumns(ShowColumns(LIST_boys, namesBoy), namesBoy, Name),
RenameColumns(ShowColumns(LIST_girls, namesGirl), namesGirl, Name)
)

Then in the dropdown items property, user the colCombineNames as the source.

Was this reply helpful? Yes No
kristinegriba 158 on at

Like (1)

Report

@jrletner Thank you! That work beautifully!

Was this reply helpful? Yes No
RoyG 31 Moderator on at

Like (2)

Report

Adding one more option that doesn't require collections -

You can use the Table function to join 2 tables, so if you want to have distinct list of names (removing duplicate names form both lists + names that appear in both lists) you could try this expression:

Distinct(Table(Distinct(LIST_boys, namesBoy), Distinct(LIST_girls, namesGirl)),Value)

Was this reply helpful? Yes No
kristinegriba 158 on at

Like (0)

Report

Thanks, @RoyG, that looks like a good solution, too! I've not tried it but will keep it in my back pocket for future reference! Thanks again... Best, Kristine

Was this reply helpful? Yes No