I keep coming up against issues with what I think should be something simple in powerapps, but I cant seem to get it workm no matter what I try!
I have sharepoint 2 lists, requests and teams. I have setup a text field in requests, "impactedteams", that I want to populate with details of any impacted teams for that particular request, using a list box control.
I want the actual items for the listbox to show the distinct values from the "teamnames" column in the teams table, and then populate the requests.impactedteams field with whatever is selected in the listbox.
Now I cant seem to get this working, it either gives me error mesages when I update the items property of the listbox, or it just doesnt update the field in the requests table when I submit (using submitform, not patch)
Am I missing something? I'm open to changing the column type from text, or even from a listbox to a combobox but nothing I have tried so far seems to have worked. I thought I could change the text field input type to a"allowed values", but this doesnt give me the option of multiple selections.
Any ideas?