Power Platform : Power Automate – Reading excel file

Hi All,

Greetings for the day!!!

One of my friend asked me how to read excel file through Power Automate. So I thought to explore it, small POC and sharing 🙂

In this article we will discuss how to read excel file using Power Automate

Details :

Excel File – Data should be in Table format

• Excel file with data – in table format as shown in below
• We have two columns – Name and Roll No

• We need to convert our sheet in Table format if its not actually
• To have selected data is part of Table – navigate to – Data >> From Table / Range option as shown in below fig

Power Automate – To read excel file

• Navigate to Power Automate
• We will create “Instant cloud flow” as shown in below fig

• Enter the flow details
  • Flow name – “Demo – Read Excel File Content”
  • Trigger – “Manually trigger a flow“

• Search for “Excel”
• Add action “List rows present in a table” to read all rows from excel as shown in below fig

• In “List rows present in a table” action enter the following details
  • Location where our excel file located
    • OneDrive / SharePoint site library
    • Excel file
    • Table in excel file
  • Here in our case, I am storing excel file in SharePoint site document library

• Once we have details in “List rows present in a table” action, we are ready to get the result
• We will use “Apply to each” action to navigate through each row in excel file
• From “Dynamic Content” select the “value” as shown in below fig

• We will use “Compose” control to output the value of “Name” column as shown in below fig

• We will “Test Flow” manually

• Please navigate through steps – Test >> “Sign In” (if required) >> “Run Flow” >> “Done”
• Once flow run successfully, we could see the output

• Following is the downloaded output – it shows both the rows from the given excel

• “Apply to each” action output as shown in below fig
• It shows two rows – and we are showing output of “Name” column

Complete Flow – Power Automate to read excel file

Thanks for reading !!! Please feel free to discuss / suggestions / share thoughts !!!

HAVE A GREAT TIME AHEAD !!! LIFE IS BEAUTIFUL 🙂