I have a canvas app that I built using the Start with Data option.
The app is designed for a user to submit an approval request. The user comes in, fills out the form, clicks submit, and the data is saved to a new record in a Sharepoint list called ApprovalRequests. ApprovalRequests has two people columns: Approver1 and Approver2.
In one scenario, the user needs to select Approver2 from a combobox called Approver2_Combobox. I want them to be able to choose from eight names which are stored in a people column a SharePoint list called CSApprover2. I eventually figured out how to get the names to display in my combo box, but when I submit the form, it's not saving to the Approver2 people column in ApprovalRequests. I believe this is because everything I do to get the names to appear in Approver2_Combobox essentially strips the other data from the people record, and the submitted data is not sufficient to populate the Approver2 people column in ApprovalRequests. I have tried various combinations with distinct, clearcollect, addcolumns, filtering on O365 users, etc. If you think one of these was the right way and I just missed an important detail somewhere, let me know.
Any advice is hugely appreciated.
