cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Submitting multiple records to Sharepoint Person column with a Form

Hello,

 

I have a Sharepoint list with a Person column. The column is set to allow multiple persons. I've connected a form with a data card to this item, and in there is a ComboBox with its Items set to Choices(ListName.PersonColumn).

 

The data card's default is ThisItem.PersonColumn, but this results in an "Expected Record Value" error. I don't really need to display the data, just enter data, so using Blank() here is fine. The update is set to ComboBox.Selected (SelectedItems seems more correct, but it also gives me a record error). 

If I submit anything with the combo box filled in, I get this error: "There was a problem saving your changes. The data source may be invalid.This was working just a week or two ago, so I'm unsure as to what the cause could be. 

8 REPLIES 8
Dual Super User II
Dual Super User II

HI @MQN 

 

The problem you are seeing might be because of the format default attribute expects.
 
To resolve this issue, please pass the below expression in DefaultSelectedItems instead of Default:
[ThisItem.PersonColumn]
 
As a combobox expects a record, we need to pass it as an array of either a single element or mutiple elements.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

That doesn't seem to have resolved the issue, although having ThisItem.PersonColumn in the combo box's DefaultSelectedItems does seem more correct than having Parent.Default and having the data card's default being ThisItem.PersonColumn.

 

I'm not much of a stickler over displaying a preexisting item from the sharepoint column in the combo box, I'm trying to get a mutiple selection from the combo box into my sharepoint ist when I submit the form. 

Dual Super User II
Dual Super User II

@MQN 

 

I am assuming that both your Sharepoint List and Combobox control in the dropdown accept multiple selection:
 
Please check if you have the following properties set in this way:
1) Default Property of Datacard: ThisItem.PersonColumn
2) Update property of DataCard: ComboBox.SelectedItems
3) DefaultSelectedItems of the Combobox: Parent.Default (No need to set the Default Value)
 
Please try this out on a new form so that there are no conflicts between the changes.
 
I have carried out a test on my side and with these properties I am able to get multiple selected result in the a edit form and submit multiple values from a new form.
 
Hope this Helps!

Thanks for the suggestions! I've made those changes, but they still seem to be having some kind of type mismatch.

The error is simply "Expected Record Value" for both, and submitting gives me the same message as before, with nothing being submitted to the sharepoint list. 

Dual Super User II
Dual Super User II

@MQN 

 

As you are getting invalid data source error, I am guessing there might be some issue with the data source connector. Can you please try to remove your Sharepoint connection, then logout of your browser, clear the cahe, relogin and recreate the data source connection. Please try this out and let me know the details.
 
Thanks, 

This allowed the form to submit, but the person records aren't going into the list. Still, this is much more usable than yesterday. Thanks!

Dual Super User II
Dual Super User II

@MQN  

Can you confirm that the update property of your DataCard is set to <<ComboBoxName>>.SelectedItems?

Yes, it's set to combobox.SelectedItems

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (70,850)