Forum Discussion

Luftgaenger's avatar
Luftgaenger
Copper Contributor
Sep 15, 2023

export only the number of the question to excel

ist ist possible like if  I have 3 options to answer

1  Very good
2  good
3  poor


when i export these query to excel there will be text exported

lets say  good       i want to have exported the result 2

lets say  20 questions and only the numbers of the options to be exportet

how can i manage without search and replace completet sentences within excel  ?

Thank you

 

microsoft forms
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Sep 15, 2023

    Luftgaenger you could do it with a simple flow in Power Automate, but other than that it's not possible.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

Resources