Forum Discussion
Microsoft Forms
I am setting up a form for my school and I need to separate data within a question. So each question should have a coded answer (ex: B11) and then a description of that answer. However, when I transf...
GabrielSzep no, if you are taking the data directly from Forms the spreadsheet will always have the full question. However if you build a flow in Power Automate to grab each response and add it to a row in an excel spreadsheet then you can strip out the description leaving just the code.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
GabrielSzep no, if you are taking the data directly from Forms the spreadsheet will always have the full question. However if you build a flow in Power Automate to grab each response and add it to a row in an excel spreadsheet then you can strip out the description leaving just the code.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Thank you!
