Forum Discussion

spark252's avatar
spark252
Copper Contributor
Aug 05, 2020

Convert entries into individual cells on Excel

Thank you for reading. :lol:

 

I am creating a "Daily Activity Report" for employees.

 

They need to list tasks: completed, ongoing, etc.

 

Would it be possible for them to list tasks in free-form text response and have that list convert into Excel?

 

Best,

Roy

 

 

microsoft forms
Survey

2 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Aug 06, 2020

    spark252 you would need to do this with a flow in Power Automate, but unless they are entering the free text in a consistent way then even the flow will struggle to split the text into different parts for adding to a table in Excel.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User