Power Platform : Power Automate – Reading excel file

by ·

Complete Flow - Power Automate to read excel file
Complete Flow - Power Automate to read 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
fig : Excel file - Table - with two columns
fig : Excel file – Table – with 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
fig : Excel file - Data in Tabular format
fig : Excel file – Data in Tabular format

Power Automate – To read excel file

  • Navigate to Power Automate
  • We will create “Instant cloud flow” as shown in below fig
Power Automate - Creating "Instant cloud flow"
fig : Power Automate – Creating “Instant cloud flow”
  • Enter the flow details
    • Flow name – “Demo – Read Excel File Content”
    • Trigger – “Manually trigger a flow“
fig : Power Automate - Creating "Instant cloud flow"
fig : Power Automate – Creating “Instant cloud flow”
  • Search for “Excel”
  • Add action “List rows present in a table” to read all rows from excel as shown in below fig
fig : Power Automate - Adding an action - "List rows present in a table"
fig : Power Automate – Adding an action – “List rows present in a table”
  • 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
List rows present in a table action
fig : “List rows present in a table” action – entering details – Excel file location, File and Table in file
  • 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
fig : Using "Apply to each" action to get the each rows columns values
fig : Using “Apply to each” action to get the each rows columns values
  • We will use “Compose” control to output the value of “Name” column as shown in below fig
fig : Power Automate - using "Compose" column to show the value under "Name" field
fig : Power Automate – using “Compose” column to show the value under “Name” field
  • We will “Test Flow” manually
fig : Power Automate - Testing flow
fig : Power Automate – Testing flow
  • Please navigate through steps – Test >> “Sign In” (if required) >> “Run Flow” >> “Done”
  • Once flow run successfully, we could see the output
List rows present in a table - action
fig : Power Automate – Flow ran successfully – Output of “List rows present in a table” action
  • Following is the downloaded output – it shows both the rows from the given excel
List rows present in a table action
fig : Power Automate – Flow ran successfully – Output of “List rows present in a table” action
  • “Apply to each” action output as shown in below fig
  • It shows two rows – and we are showing output of “Name” column
Compose action
fig : Power Automate – Displaying values of “Name” column using Compose action

Complete Flow – Power Automate to read excel file

Complete Flow - Power Automate to read excel file
fig : 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 🙂

Tags:

Prasham Sabadra

LIFE IS VERY BEAUTIFUL :) ENJOY THE WHOLE JOURNEY :) Founder of Knowledge Junction and live-beautiful-life.com, Author, Learner, Passionate Techie, avid reader. Certified Professional Workshop Facilitator / Public Speaker. Scrum Foundation Professional certificated. Motivational, Behavioral , Technical speaker. Speaks in various events including SharePoint Saturdays, Boot camps, Collages / Schools, local chapter. Can reach me for Microsoft 365, Azure, DevOps, SharePoint, Teams, Power Platform, JavaScript.

You may also like...

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: