Build excel file from string of bytes

[Anonymous]

I have a use case where a service will email an excel file to a service account's mailbox. 

Once the email received with excel attachment, it should open up and loop every single row.

I am able to get my flow to detect and open up the attachment, read the attachment bytes into a variable, but how could i loop through the rows in the excel attachment?

At first i tried to "Get Worksheet" but i stuck. The options only allowed me to grab the excel file from OneDrive and SharePoint. My only way to grab the source file is via email.

[bradleyhorton]

@Anonymous  as part of the flow you could save the attachment to OneDrive or SharePoint, then use that file and then delete it after?

[Anonymous]

yeah, that's inspring after i post this thread. I managed to push to SP and pull out the excel

Next step, how could i loop the rows out? 

[bradleyhorton]

@Anonymous if the information is in a table you can use 'list rows present in a table' and then apply to each from the output. I'm afraid I don't know how to get it if the information isn't in table.

[Anonymous]

@bradleyhorton That's exactly what i am facing. 🙂 

I probably have to re-think my process.

Thanks anyway!

[bradleyhorton]

@Anonymous  saw this and thought of you https://powerusers.microsoft.com/t5/Connecting-To-Data/Extract-Rows-from-Excel-CSV-No-Table/m-p/749310#M10668