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 how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.