Power Platform Community Forum Thread Details

Power Apps Team,

I’m trying to populate a SharePoint column from a drop down drawn from data in another list.

Simplified example:

SPList1: Column UserName, Column FavoriteFood

SPList2: Column FoodName

All columns are single line of text

What I’ve done so far:

I’m having trouble showing the chosen item in the ComboBox after EditForm1 is submitted.

Assumptions:

The example above is simplified.
I can’t use an SP Lookup column because I’ve exceeded the SP limit for number of lookup columns. I need 50+ lookups that choose from 8 rows in a single list. I’m using Collections to filter out this table.
I would like to avoid Choice Columns, because the real version of SPList2 is 150 items long and will need to be updated.

Request:
Can someone share the properties that they would use to set up an EditForm/ComboBox in my example? (Links are helpful too.)

Regards

Categories: