Microsoft Power Automate | How to create a flow and update an Excel Table | Tutorial

In this guide, you'll learn how to create a flow and update an Excel Table directly from Microsoft Power Automate.

You could also watch:

00:18 Inspect Excel data
The data for our simple Power Automate use case is quite simple (ID, Name, Sale). It is important, that you have formatted your Excel data as a table.

00:52 Create Instant Flow
We create a manually triggered flow, but you could fine schedule or trigger your Power Automate flow.

01:20 Manually Trigger a Flow (Text and Number)
A unique identifier and then two columns of sales data will be inputted, when the Power Automate flow run.

02:18 Add a Row Into a Table
To update our Excel table with a new row, we chose 'Add a Row Into a Table'. Specify Location, Document Library, File, and Table. Finally specifying the dynamic content.

FOLLOW ME:

#powerautomate #microsoft #excel

[charlesyorke]

A great video! It helped me a lot with my approval flow! Thank you!

[shrutigoursetti]

This is really helpful video. Thanks a lot Anders.
Can you please let me know if we can update power BI report whenever there is update in excel? Please let me know if you have any video or steps how to do it. once again Thank you

[gosodre]

Hello Anders, thanks for the content. Do you know if it's possible to use dynamic tables? Lets suppose that I've one excel but with many tables and based on the month I will update a specific table. Please let me know if you have any solution for that. Thank you.

[evangelizarEC]

Hello. In the example you typed ID 2. Do you have an example so that the ID number is automatically added to the next one based on what's already on the Table or one where it automatically adds based on date/time that one is inputting the data?
Thanks Anders.

[kren]

amazing video!
is it possible to update the specific cell which is not on the table data?

[tiffanyw]

Hi Anders, thank you for the helpful information! I wanted to kindly ask for assistance with Power automate flow please. 

I have two excel workbooks in one drive: one is my personal tracker workbook that has several columns but I only want to automate two columns named Audit 1 and Audit 2.  Based on the data I am auditing, when complete in the Audit 1 column I will always type the word "complete" in every single row, and Audit 2 I will always type the phrase "ready to file". in that column for every row.

The other workbook is the master tracker, which is tracked by supervisors. It has different columns than my master tracker, the only exception are Audit 1 and Audit 2 based on what I enter in my personal tracker.  They want to track my progress and see when these audits are complete in this master tracker.  So my question is each time I update Audit 1 and Audit 2 columns in my own tracker workbook, how can I make it so that the master tracker workbook Audit 1 and Audit 2 columns also update with the same data?  Thank you for any insight and help!  I am new to automate.

[TheRemyRomano]

Nice. Do you know any PA tricks to convert older XLS file to XLSX?

[SFCStevens]

So instead of just opening Excel and filling out a new row, is there any real advantage of doing it this way? My guess would be to have the results end up generating in some type of a dashboard somewhere or maybe an automated email? That could be a possible 'part 2' to this video. I'm wondering what if there are any other benefits though.

[DavidPrenticeJr]

How would you check for a duplicate entry before the data is added?

[dandyventures]

I am trying to learn Power Automate to see if I want to use it. Searching YouTube I run across this Video but after watching it seems like maybe one must have BUSSINES to utilize. 1) Is this true as I just have HOME. 2) If true, appreciate if limitations to BUSSINES would be in your title. Thanks

[gayathrij]

I have a flow for creating and updating an items but the column formatted as a Number in SharePoint not accepting the Blank values. Can you please help me to fix this issue

[kannann]

Hey I want to know how to update a particular cell after action completed

[prod_adrian]

Table error, does not work. my excel has no name or tag for any table, cant even find it in the dropdown menu...

[tahirif]

I dont see how its different than adding a row manually? running a flow and entering the data and hit run again.

[PedroTannus]

There's no Update in this video. This is an ordinary "Add/Insert" on a table. Be carefull!