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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.