Combobox values from separate sharepoint list not submitting

[admincaleb]

Hi - I'm new to powerapps (not a developer at all 😄 ).  I started creating a powerapp based upon a form which is based upon a sharepoint list (let's call it List1).  The fields in this list are either free text, or have options to select that are hardcoded from the (list1) sharepoint list.  There is only one field (let's call it teams) that has no values hardcoded and would require values from another list (this is because the values fluctuate often, and we have a single source of truth for these values).  Let's say these values are in a separate list (list2).

I am able to pull the values from list2 by doing the following:

Items Property : [@'list2 name']

This enables the user to multi select all values from this list.  This is exactly what I want to achieve.

I created a button that "OnSelect" will SubmitForm(Form1).  All of the values the user entered are pushed to list1, except the values the user entered from the teams field (which is where the values are dynamically populated from list2).

What am I missing here?  I'm assuming there is something that is not linking the data from list2 when clicking the Submit button?  Or is it something to do with the "list2" data type not being some kind of "Choice" but instead is plaintext?

[madlad]

Hi!

From what you've described, it sounds like it likely is that List2's items aren't valid or don't match the choices for the teams field most likely.

How do you define the options for the teams column from list 2?

If the options are set up correctly, you should be able to get away with something like:

Choices([@'list1'].teams)

in the combobox's items property

In general for your scenario, the choices function is generally safer than having a list match the columns options, I would recommend looking into it a bit further.

Hope this helps! 🙂

[admincaleb]

Thank you for the reply.

How do you define the options for the teams column from list 2?

• The options available in the "teams" column from list 2 is a power automation that updates a sharepoint list based upon changes in an excel file.
• If change in {name}.xlsx, then check if a new row with "team name" exists in "list 2".  if it doesn't, then add the new team name.

Looking at the working fields (from list1) the items property is like this:

• Choices([@'Disaster Problems'].ResponseType)

However, when I do what you said (but including the actual names) I get an error:

• Choices([@'Management@Group Responsibility'].'Team Name')

[@'Management@Group Responsibility'] is the name of the "list2" sharepoint list.

'Team Name' is the name of the column where the "team" values exist in the sharepoint list.

Example of the "list2" sharepoint list (they are just rows in text form)

Purpose of the app is to have personA push some information through manual intervention for each field except the team name.  the team name list needs to populate dynamically based upon other lists (change often)

[admincaleb]

i believe its due to the list being "text" and not "choice".  i tried incorporating a solution via power automate with sharepoint get via uri and api, but its disabled by my org.  i believe the only solution here is to manually input the changes into the list.