Convert entries into individual cells on Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1567503%22%20slang%3D%22en-US%22%3EConvert%20entries%20into%20individual%20cells%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567503%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20reading.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Flaugh_40x40.gif%22%20alt%3D%22%3Alol%3A%22%20title%3D%22%3Alol%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20%22Daily%20Activity%20Report%22%20for%20employees.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20need%20to%20list%20tasks%3A%20completed%2C%20ongoing%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20it%20be%20possible%20for%20them%20to%20list%20tasks%20in%20free-form%20text%20response%20and%20have%20that%20list%20convert%20into%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3ERoy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1567503%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570139%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20entries%20into%20individual%20cells%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F750312%22%20target%3D%22_blank%22%3E%40spark252%3C%2FA%3E%26nbsp%3Byou%20would%20need%20to%20do%20this%20with%20a%20flow%20in%20Power%20Automate%2C%20but%20unless%20they%20are%20entering%20the%20free%20text%20in%20a%20consistent%20way%20then%20even%20the%20flow%20will%20struggle%20to%20split%20the%20text%20into%20different%20parts%20for%20adding%20to%20a%20table%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

 

 

2 Replies
Highlighted

@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

Highlighted
I see, thanks for letting me know!