Hello!
I have 2 Sharepoint Lists for my PowerApp: Projects & Users
Projects has fields ID, Assigned To (mult-select people picker)
Users has fields ID, UserRecord (single-select people picker), Specialty
Relevant Powerapps elements:
comboAssignedTo (combobox)
labelSpecialty (label)
Outcomes:
- Filter the Projects.'Assigned To' people picker combobox comboAssignedTo choices to ONLY show people that are in the Users.UserRecord list & save the combobox selections to Projects on form submission
- Populate labelSpecialty text with the Specialty values from the Users list based on selected items in the combobox comboAssignedTo (concatenated for multiple selections)
where I'm at:
I have the comboAssignedTo displaying the records i want with this as the items property:
With(
{
_prefiltered_users: Filter(
Users, ID > 0
)
},
Sort(
ForAll(
Ungroup(
_prefiltered_users,
UserRecord
),
UserRecord
),
DisplayName,
SortOrder.Ascending
)
)
but when I try to save the record, I get a patch error (no details, just "Network error when using Patch function: An error occurred on the server.")
**I've tried refreshing the data connection, same error
I've got this for the labelSpecialty label text property so far but it errors out:
Concat(comboAssignedTo.SelectedItems, Value & ", ")
do I need a 'For All' in here somewhere?
Thanks in advance!!
