@Megan_V_Walker It's been a while since you posted. This now kinda works. I ended up with a massive list in option one but then it broke it down into individual options. Then I just needed to delete the option one with it all in.
I have a survey set up in forms that I intend to use to contact around 30,000 vulnerable customers during COVID lock down. Currently we're having to cut and paste data from Excel individually into forms for each survey. Is there a way to pull that data automatically so groups set up in teams can just open a form pre populated and complete a survey with the next customer data pulling through once completed ?