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...
RobElliott
Aug 19, 2021Silver Contributor
pcorbitt if the team members are all within your organisation then Office 365 knows they are so you don't need to ask them each time for their personal information. You just need to make sure in the form settings that "only people in my organisation can respond". What we always do (for backup, audit etc) is to have a flow in Power Automate that grabs each response and saves it to a SharePoint list, automatically populating it with the name, email address and other info from Delve. In my company we don't store each individual's office location in Delve so if this info is required we ask them in the form via a choice question.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
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.