Aug 18 2021
11:10 AM
- last edited on
Aug 03 2023
06:52 PM
by
TechCommunityAP
Aug 18 2021
11:10 AM
- last edited on
Aug 03 2023
06:52 PM
by
TechCommunityAP
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 name, office, date and the project info into a new spreadsheet for management. We would like to encourage participation by minimizing the number of times each person has to enter their own personal information, either a) allowing them to accessing their location/title/etc. from the name/office spreadsheet to begin each survey or b) having that information carry over to the next survey or c) allowing them to enter multiple data sets in each survey. Any thoughts? How have you addressed this?
Aug 19 2021 02:03 AM - edited Aug 19 2021 02:05 AM
@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
Aug 19 2021 06:48 AM
Aug 19 2021 06:53 AM - edited Aug 19 2021 06:54 AM
@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)