Share
ReportPower 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:
- Create EditForm1 from SPList1
- For the FavoriteFood DataCard, remove the Text Box and insert ComboBox1
- ComboBox1 Items=SPList2.FoodName
- DataCard Update = Concat(ComboBox1.SelectedItems, FavoriteFood)
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:
I have the same question (0)
All responses (
Answers (
119
