You’re offline. This is a read only version of the page.
I am trying to create a flow that takes individual forms responses as shown and creates an individually named excel file containing a tranposed version of the responses
| Candidate Number | First Name | Last Name | 1 | 2 | 3 | 4 | 5 |
| 12345 | John | Doe | A | B | A | C | D |
into this format (an excel file called '12345_First Name_Last Name) for subsequent import into SQL DB
| Candidate Number | 12345 |
| First Name | John |
| Last Name | Doe |
| 1 | A |
| 2 | B |
| 3 | A |
| 4 | C |
| 5 | D |
Can anyone help/advise please?
Hi Koen
Thank you for your detailed response. I don't have much experience of Forms or Power Automate to be honest but I think I grasp the concept. Sadly I cannot change my form format, it has to be this way. I do have admin rights and would happily listen to any suggestions you may have with a view to maybe altering the way I do this task.
Thanks
Andy
Dear AndrewMac,
I see 3 options to achieve what you want, but before that, I am wondering what you eventually want to do with the data. It seems to me that the structured data (table) you get from the form is perfectly suitable for any kind of analysis you need. Your solution may lie in changing the way you use the data.
Anyways:
Hope the suggestions help you further along.
Happy flowing,
Koen
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (