Hi, I have a SharePoint List which logs individual service desk incidents. ( a flow from a shared mail box+ some manual entries.) I want to build an automated (or semi automated) "survey" mechanism fulfilling following needs:
1- When a Column (Status Column) value is changed to "Resolved", it automatically send out a simple survey to the incident initiator (the email of the incident initiator is stored in a column in the list)- This part is easy and i can get it triggered easily.
2- I want the survey results to automatically update the related column fields of row of that particular incident in the SharePoint list. so if i create only one MS Survey Form to be used for all incidents, how will it log the results against its related Row in the list? I was thinking of automatically populating the form with incident number when it goes out to each Initiator- and when the results are submitted, the flow "cross matches" the incident number and then populate the specific row only. OR should i use a separate list to get the results from the form logged first and then populate my original incident log list's related columns by Lookup or another simple flow? what would be the best approach.?
3- I also want to only let one response per incident (not per person). b/c same person can submit two different incidents and he/she should be able to submit survey feedback for each. But should not be able to submit more than one response for one incident. Could not get my head around, what can be done to achieve this functionality?
Thanks
