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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!