Hi,
I have created a SharePoint List which contains all my client details in columns. I also have an MS Form with the same fields (named same as the List columns), which collects updated client details directly.
What I would like to do is develop a flow that does the following:
- monitors responses to the form
- sends me an email summary when a form is submitted
- checks the Sharepoint List to see if the client exists on it - using first name, last name and date of birth dd/mm/yyyy
- adds the client to the List if they don't appear on it
- If the client does appear on the list, the new details captured in all other fields on the form over-writes existing data on the SharePoint List
- Emails me a summary of the changes made to the SharePoint Record.
Is this possible? Would sincerely appreciate the help!
