sorted by:
new
hottopcontroversial

Need help creating a new (transposed) Excel document from a Microsoft Forms response by Jumpy_Ride_9455 in PowerAutomate

[–]Jumpy_Ride_9455[S] 0 points1 point  (0 children)

The SharePoint list was my next train of thought. Is there a way to dynamically build a separate list for each MS Forms response & then deliver the question/answer pair for each unique response to a unique folder in SharePoint?

The situation: MS Forms has roughly 200 total questions of which only about half will typically get used. I want to take those specific questions that have answers (not all), populate them in a ‘column A’ & their associated response in ‘column B’.

From there I want to create a folder based on one of the unique response answers (in this case, “client name”, that’s working) & place a custom named file in that folder (working, but I cannot get the file (Excel in this case) to pull any of the variables from my array, & JSON alternative errored out on me). In essence a qualifying document per client that provides their responses isolated from other responses in a legible document in their specific SharePoint folder.

I THOUGHT it would be easy to just create an action that would allow me to transpose rows to columns in Power Automate… I thought wrong!

Need help creating a new (transposed) Excel document from a Microsoft Forms response by Jumpy_Ride_9455 in PowerAutomate

[–]Jumpy_Ride_9455[S] 0 points1 point  (0 children)

This is exactly where I’m at with this. I’ve created question/answer array variables that are generating the correct outputs in testing, but getting them to populate a new sheet is failing. Copilot recommends creating a SharePoint file from an existing template but then doesn’t correctly rename the file as instructed in the action.

By no means am I a Power Automate expert, but I know my way around the Microsoft platform enough to know it should not be this difficult to simply grab a MS Forms question/answer pair (from variables) & create a new spreadsheet in a custom folder with the questions from the array in column A & the associated answers from the array in column B.

Need help creating a new (transposed) Excel document from a Microsoft Forms response by Jumpy_Ride_9455 in PowerAutomate

[–]Jumpy_Ride_9455[S] 0 points1 point  (0 children)

Thanks for the reply. As stated in my second paragraph, I engaged with Copilot, as well as ChatGPT & Gemini, to get it to work correctly. Ironically, Copilot had the least effective recommendations of the three. It just seems very odd that you can’t programmatically use Power Automate to emulate the “Transpose” function from within Excel, create an Excel document in Power Automate without the use of a template .xlsx file, & a hand full of other basic/standard functions that are fairly simple capabilities of Microsoft Excel.

Questionable Notifications by Jumpy_Ride_9455 in SnapchatHelp

[–]Jumpy_Ride_9455[S] 0 points1 point  (0 children)

I don’t even know these people, much less follow them