Answered

Getting the DefaultSelectedItems for a form combo box field from a lookup of another SharePoint List

(0) Share

Report

Posted on by bryan0920

I have a PowerApps form in edit mode. The source for the form is RI_Tracker. For five fields I need to populate the DefaultSelectedItems with lookup values from another sharepoint list named Program_Funded_Lookup.

Basically, when the user selects a Funded_Program code, the five fields lookup this Funded Program code and populate the DefaultSelectedItems with a field in the same row (like a Vlookup).

Here is a snippet example.

When the user selects the Funded Program code from the combo box the 'CSU/CSU' DefaultSelectedItems should show the 'CSU/CSU' value from the Funded_program_Lookup SharePoint List.

I have tried many different functions including:

LookUp(Funded_Program_Lookup,Funded_Program = FundedProgramValue.Selected.Value,'CSC/CSU')

Using this I get an Expected Table error. Can someone help me out please?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bryan0920

The problem you are facing is that you are using a LookUp function to set the DefaultSelectedItems property of a combo box, which expects a table value, not a single value. That’s why you are getting an Expected Table error.

Use the Filter function instead of the LookUp function, which returns a table of records that match the condition.
You can try this:
Filter( Funded_Program_Lookup, Funded_Program = FundedProgramValue.Selected.Value )
This will return a table of records from the Funded_Program_Lookup list where the Funded_Program column matches the selected value of the FundedProgramValue combo box. You can then use this table as the DefaultSelectedItems property of your CSU/CSU combo box.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
bryan0920 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much and that makes sense. So that gets me to the row of the lookup list. How do I integrate it with selecting the column value I want? For example the CSU/CSU column in the Funded_Program_Lookup list?
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

In Powerapps Studio you can select the ComboBox and then at the right you select Fields and select you column you want to show as the Primary Text.
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
bryan0920 6 on at

Like
a
(0)

Report
Copy link

Link copied!

It did not work as expected. I anticipated it would populate the box, but it populated the options instead, which is great. Thank you for the help!