Power Platform Community Forum Thread Details

Hello

I have 2 different tables with values that I want to populate a field with. I want to have names and ids from each db available in that field. So, the user can pick from values from BOTH dbs. The resulting name and ID are sent to another, different DB. I am not quite sure how to do this.

So the end user would see in a dropdown

"name1, id1"

"name2, id2" etc

but the names and ids come from 2 different tables with different column names.

I have the 2 columns from each DB that I want as two different collections. But where should I go from here? How should i merge them?

Thanks a lot!

Categories:

Building Power Apps