Microsoft Power Automate | How to create a flow and update an Excel Table | Tutorial
Vložit
- čas přidán 25. 01. 2020
- 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:
🔵 Microsoft Power Automate Tutorials - • Microsoft Power Automa...
🔵 Get Forms responses to Excel with Power Automate - • Microsoft Power Automa...
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:
💼 LinkedIn: / andersjensenorg
🐦 Twitter: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
👨👩👧👦 Discord: / discord
💌 Email Newsletter: andersjensen.org/email-newsle...
#powerautomate #microsoft #excel
My new complete Excel with Power Automate guide is here: czcams.com/video/PlCnYDkbw3I/video.html
Thanks for all your support 🙌🔥
Hey guys, check my new Power Automate Tutorial for Beginners - czcams.com/video/omQ-fAF4QpI/video.html
A great video! It helped me a lot with my approval flow! Thank you!
Hey Charles, thank you very much 😊 Let me know, if you have any questions or suggestions to new videos in the future. Kind regards, Anders
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
Hey Learner. Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
good stuff mate
You're very welcome, Ian Clark - your support helps me a lot 😍
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.
Hey Felippe. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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.
Hey evegelizarEC. I would let an Excel Table handle that (where our sheet is) - if I understand you right (that we want to take the ID input away from the user and do it automatically). Kind regards Anders.
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.
Hey Tiffany W
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: czcams.com/video/_QRI-Yo2h8U/video.html
Have a great day.
Kind regards,
Anders
amazing video!
is it possible to update the specific cell which is not on the table data?
Hey K Ren
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: czcams.com/video/_QRI-Yo2h8U/video.html
Have a great day.
Kind regards,
Anders
Nice. Do you know any PA tricks to convert older XLS file to XLSX?
Hey Remy Romano
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: czcams.com/video/_QRI-Yo2h8U/video.html
Have a great day.
Kind regards,
Anders
How would you check for a duplicate entry before the data is added?
Hey David Prentice
Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: czcams.com/video/_QRI-Yo2h8U/video.html
Have a great day.
Kind regards,
Anders
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
Hey Gayathri. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
I am trying to learn Power Automate to see if I want to use it. Searching CZcams 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
Hey David. You can use Power Automate without a Business license, but I will say, it works best with business. What you can use for free is the RPA part (which is great). Check this: czcams.com/video/1WezrCQlpBY/video.html Kind regards, Anders
Hey I want to know how to update a particular cell after action completed
Hey Kannan N Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: czcams.com/video/_QRI-Yo2h8U/video.html Have a great day. Kind regards, Anders
Table error, does not work. my excel has no name or tag for any table, cant even find it in the dropdown menu...
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
I dont see how its different than adding a row manually? running a flow and entering the data and hit run again.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders
There's no Update in this video. This is an ordinary "Add/Insert" on a table. Be carefull!
Hey Pedro Henrique Tannus Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: czcams.com/video/_QRI-Yo2h8U/video.html Have a great day. Kind regards, Anders