Forum Discussion
Hide data records collected via Microsoft forms based on user account or group membership?
If you respondents to see the responses but only those from their department then you won't be able to do this Forms on its own. You'll need to have a list in SharePoint for each department (with the permissions set appropriately) with a column for each question. Then have a flow in Power Automate that gets each response and based on the department save the response into the relevant list.
I do not quite understand your solution. Am I correct in assuming you are suggesting the following:
- Have 1 single Form that all departments use. Users filling out the form should not be able to view the collected answers, only upper management should have that ability. That way they have one point of refenrence to see ALL info of all departments.
- In the backend also create different Sharepoint lists, one per department.
- Based on the field "department" in the Form, redirect the answers to the questions in the form to the correct department list
Is my assumption of the flow described in the above 3 bullet points correct?
Somehow point 3 could be achieved with some Power Automate code? But I do not quite understand how yet.
Upper management already has the Forms way of working set up and it is running. They need to see all answers of all departments and they want it in one place (not in different lists, that would mean they have to consult different sources of info to do their analystics on). So we need to expand upon the already implemented solution (they obviously did not analyse thoroughly enough before implementing this, but that is another issue)
If it is only specific upper management people who need to see all the responses then just give them the collaborate link. But if all staff in a department need to see the responses from their department then you will need to do it the way I suggested before because Forms has no way to do that.
Yes #3 is a flow in Power Automate. It's not code, it's all visual.
