Forum Discussion
Collecting Survey Respondent Specific Data
Indiemusicboy - hi - you cannot use the CSV import file to import data other than the First Name, Last Name and Email address at this point in time. You could store the CSV file in OneDrive or SharePoint, then create a flow in Power Automate that runs on-demand, and uses the values in the CSV file to pull the variables you need, but you will not be able to do this by importing the CSV file into Forms Pro.
Thank you Megan_V_Walker. So if I understand this correctly, I would have a master (all customer) CSV file in ODSP and then create a flow in Power Automate that uses values to pull from the master CSV.
So when I want to send the Forms Pro survey to say 5 of the 500 customers in the master CSV file, would I simply import a CSV with the email, first name, last name of those (5) and then the PowerAutomate flow knows to pull in the appropriate Variables from the master CSV for that survey and its email?