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.
@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 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
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
If you are a small business ISV/Reseller, share your thoughts with our research team.