Forum Discussion
pcorbitt
Aug 18, 2021Copper Contributor
User-Friendly Data Survey
We have an Excel file in SharePoint which contains a list of our team members across several offices. We need to gather multiple data points for numerous projects from each of them and drop their nam...
pcorbitt
Aug 19, 2021Copper Contributor
Thank you, Rob. Unfortunately, there are several members of this group that exist outside of our organization. We are hoping to loop in those offices by utilizing an MS Forms survey to gather their data and ours together in one sharable place.
RobElliott
Aug 19, 2021Silver Contributor
pcorbitt then you have no option but to ask them for their personal info each time they complete the form. But if you have 2 forms, one for internal staff and one for external, then you can use a flow in Power Automate to save each response from both forms into a single SharePoint list.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)