Oct 11 2019
- last edited on
Aug 06 2023
I have a situation where a salesperson within our organisation requests a Form be emailed to one of their customers by providing the customer email via a PowerApp. This creates a record in SharePoint and Flow then emails the customer a link to complete an MS Form. Once the Form is complete I want to store the values in SharePoint. How would I identify the SharePoint record that needs to be updated? I see there is no way to send the form with a pre-populated field (say customer email address) which could be used as an identifier when the form returns.
Oct 12 2019 05:56 AM - edited Oct 12 2019 05:58 AMSolution
Hi Colin @Colin2307, the way to do this is to include the ID number of the item in the SharePoint list in your email. The client then needs to add this number into a required question in the form. A second flow then runs when they submit the form and updates the record based on the ID number.
Images of the different steps are below. Hope it helps.
Microsoft Flow Community Super User
Oct 12 2019 06:02 AM