So, I have a form in my PowerApp linked to a SharePoint list. Within that form, I have two data cards each with ComboBoxes that are connected to a secondary list within the same SharePoint site. If the user entering the form selects "TEST" from the first ComboBox (ComboBox1), it automatically selects the corresponding user from ComboBox2. So, if I choose "Test" from ComboBox1, ComboBox2 automatically updates to my name, "Wilson, C (Courtney)".
A couple things...
- I want this data to be retained. Right now, when a user saves the form and comes back into it, the selected item in ComboBox1 and ComboBox2 are both gone. Blank.... why is this?
- I then want those ComboBoxes to Patch/Update the column in the main list being used for the form. So, in the main form (SharePoint List 1), there is a column for "ControlBreakdown" (ComboBox1) and "RiskAdvisor" (ComboBox2). The ComboBoxes are connected to another list in the same SharePoint site (SharePoint List 2). When someone chooses "Test" from the ComboBox1 (SharePoint List 2), I want it to patch / update the column in SharePoint List 1 with the choice they selected from ComboBox1 and ComboBox2.
- When ComboBox2 is automatically populated with the user (connected to a Person/Group column in SharePoint), I want to be able to get the email address from that column and send that user an email.
How can I do this? Please help, thanks!

Report
All responses (
Answers (