Hi,
I have created a canvas app based on a SharePoint list that contains some fields, nothing special. One of them is a people field 'Assign to' where I need to be able to select a person from existing accounts. Works fine.
But when I open an existing item, click Edit and change some fields, including replacing the person in the people field with another person, all changes are saved, except for the change in the people field. Still shows the first person.
My 'Save' button simply says SubmitForm(MyForm) & Navigate(OtherForm)
What am I missing...?
Your help will be much appreciated! 😉
Wendy
Solved! Go to Solution.
I removed the datacard and added it again, and now it works.
It was behaving very strange. I was even allowing me to add 2 persons, didn't gave me an error but didn't save. Also, in SharePoint it wasn't defined as multi select, but in the Power Apps properties, the switch of multi select was on! 🤔 So I think it got corrupted at some point.
But thanks a lot for your help @RandyHayes , you definitely helped me re-evaluating the multiselect thing. 😉
My first question would be, is the column defined in SharePoint to allow Multiple people?
If so, then that could be the source of the issue.
No, not defined as multi select...
Well we can check that one off the list!
I will assume you have created a Canvas app (as opposed to customizing the forms in SharePoint) and that you have either created that From Data or that you added your own EditForms. (if this assumption is off, please inform)
So, what is the Update formula on your Assign To datacard?
Yes, created a canvas app and I use SharePoint lists as data sources.
The Update formula is the default: DataCardValue11_3.SelectedItems
And you altered nothing else??? That formula should be DataCardValue11_3.Selected !!
I tried to repeat the steps with a SharePoint list that has a Person column (single person) in it and created an app from Data and chose that list. I did this just in case the was some new issue with doing so. But, my formula was correct on the EditForm DataCard.
I removed the datacard and added it again, and now it works.
It was behaving very strange. I was even allowing me to add 2 persons, didn't gave me an error but didn't save. Also, in SharePoint it wasn't defined as multi select, but in the Power Apps properties, the switch of multi select was on! 🤔 So I think it got corrupted at some point.
But thanks a lot for your help @RandyHayes , you definitely helped me re-evaluating the multiselect thing. 😉
User | Count |
---|---|
248 | |
106 | |
82 | |
51 | |
43 |