How to update Excel sheets from Power Automate - Ultimate guide 

Thank you, Alireza! Great content! I'm learning so much!

Thank you, Alireza! Good stuff! Now I can stop pounding my forehead against the desk.

I am following you Alireza from CSOM tutorial days and your way of explanation is beyond my words, I am also following your udemy tutorials for Automate, you are a saviour honestly. Can you please make some tutorials on PowerApps, I did found one video here and not sure if there is a tutorial like full Automate ones for PowerApps as well.

Really appreciate how you make your videos practically from actual user problems. Very valuable content.

Thank you Alireza ! Very informative content. I am new to Power Automate and wish to learn ways to create an automated excel document containing Jira issue from a Jira filter using Power Automate. Can you make a video to show the ways to do it? Thank you in advance. 😄

The video that I saw looking for, thanks pal!!!!

Great video! 👍 *Thank you very much!* :)

I'm encountering an issue where my script calls a URL using fetch when integrated into Power Automate. It throws the error 'fetch is not defined'. Do you have a solution?

Thank you for your amazing and valuable sharing!

Need to update and/or create many rows in Excel? Try Excel batch actions in Power Automate: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HiEU34Ix5gA.html

Instead of ID column which contains integers, could we use the Name column (text) as the key column?? Will this work??

Thanks Alireza for such helpful content. Is it possible to copy the latest data from one excel file and add it to another excel file using power automate? Thanks for your response.

when power automate update each ID at trigger like that, does it Refresh All and Save the file online automatically as well without user have to touch anything?

appreciate if you can share how to update excel which data is added from the top (just below the header) and not on the last row. thank you.

Thanks for the video . Is there any way to get the name of the columns ? In my task, I need to correct the schedule of employees, and I need them to enter the name of the day of the week, and power automate, compared this value with columns and put the value in the required cell. Or can this task be implemented in some other way ?

Thank you for your videos sir, could you please let me know if we can automate any web forms by picking the data from google sheets instead of using excel?

Great video. What if the 'UnitPrice' column in Excel is formatted as 'Currency' ? E.g. $214.09 . How would you use float expression in Power Automate?

Hi, Really good video on Power automate and Excel. Do you have something similar using Power Automate to update and .csv table in the File System. I would like to update every row excluding the header and footer add/remove spaces and insert a few characters, always same area on every row. Just one Colum

hi alireza, im trying to update a hyperlink field with the keeping the name of the hyperlink same, the issue is that the value stays the same as the first item picked and duplicates it to all the rest items, although its part of apply to each action, i dont understand the behavior. i using the formula hyperlink() in automate, when i check the flow it self i can see the values are picked correctly, but when i go to the excel file the value are duplicated, any ideas?

Hi Alireza, Thanks for your effort and great video! I just have one question. I did exactly what you described in this video but after Parsing to JSON I want to use excel file information as OData filter in List rows. For doing that I am using JSON dynamic values but the issue is that although the value I am using is a number and I am converting it to integer, it doesn't work and getting this error: "A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.Int32' for operator kind 'Equal'." The value is converted to integer properly without getting error but I cant use it in List rows as a filter (I tried without converting but it didnt work either).

Hi. With Flow, how we can get flow to increment the ID by 1 each time?.

That's was exacly what I looking for. Thank you]!

I find it changes but anything reading from it doesn't get updated

You should also check the Udemy courses by Alireza. Really awesome!

Fantastic content! Congrats

After taking your courses on Udemy, these updates are very useful. Thanks so much. However, I tried to read a table inside a file containing Macro, with the extension xlsm, but Flow does not see it. Is there no way to read it?

My man, I am tired too. I'm going to bed now. I'll think about this more after a good night's sleep.

brilliant!!

Thank you :)

so basically we want to describe a pretty straightforward update task, but it takes five sophisticated workarounds to get it done. Microsoft really knows how to keep the consultants in their ecosystem busy :-(

way too complicated for simple flow

Thank you Alireaz, you are amazing and great value add in my skills.

Thank you very much ? Can you also refresh an external data source (power query) in an excel sheet using power flow?

I love the way you show us step by step, even from the mistake. Respect! and Subscribed to you channel!

Is it possible to extract the data from forms. So that the forms document is the trigger function? BTW. Great Video!

Thanks a lot for your tutorial after comment. It was very helpful. One flow I tried to create would copy a template Excel file (with 1 table), rename the file, and then try to update the table. I could not find a way to update the table on the new copy of the file, so I ended up updating the original file before copying but then I had to perform a second update to the original to blank all the cells.

Thank you for this very helpful video. I have one question: Is there a way to update an excel row using a composite Key (from 2 or more Excel columns)? Thank you very much in advance

How do we update an Excel file which has Power Query and I just want to refresh the Power Query? means I just want to refresh the entire dataset in a specific excel file

Hi .Can you create a video how to combine excel files using power automate and load back to share point

Hello Alireza Aliabadi, How we can extract whole excel attachment from the mail through power automate and it has to store data in SharePoint location every month?

I have a question, how I can a make a flow to Update the entire Excel sheet from the Excel query

Love it. I've been learning from you for over three years ❤

Thanks for Sharing. Would have taken me hours trial and error.

The biggest no no - what I'm trying to do is insert custom file path depending on values it gets from flow. Even if it's exacly same value - still can't manage get it and it says it wont find for example: my file path is /Products/Project_Name_1/schedule.xls So for example we have 100 folders listed from Project_Name_1 to Project_Name_100. I create variable and just say set this variable to Project_Name_1 Now when he goes to same path with variable /Products//schedule.xls - it does not understand, if you just click manually it works. No idea how to fix it.

still a great video - thank you!

how to automate refresh date on excel

I dont uderstand how to update row in any Excel file. Not specific. If i want apply one rule for all files un library?

I receive my bank transaction report daily in csv format by email attachment can I power automate to update 1 excel sheet for all the daily transaction

Hi Alireza, great video and had tried and using Name as the Key, however if there are two records with same name, for e.g. Mark, 23 (Age), 101, Mark, 34(Age), 108, using your same example, mul(1.1, float(items('Apply_to_each')['Numbers'])), only first Mark is updated with 118.1 (which is wrong suppose to be 111.1), and the 2nd Mark didn't update at all I change the Key Column to Age (suppose to be Unique unless both mark same age) then the flow correct is there a way in Power Automate to have composite Key ? i.e. Name & Age Thank you !

Great info here

Hello friend, I want to automatically process the daily excel stock files sent to me, but the company does not give the stocks in *numbers*. for example stock = "low", stock = "better". How can I convert them to numbers and update my stores? thank you

thank you

Thank you! Really great. How can I update excel with not unique ID´s? In your example with ID 3. This ID should always be changed to 577 several times.

Great and remarkable at the same time. But does Power Automate allow copying a value from column A to column B? Can someone give me a hint how this could be realized?

Hello i talk from colombia, thanks for your videos, i have one question , if i use contains in the filter my flow search primary key distributed in the excel

Thank you Alireza, much appreciated!!

Thanks this was super helpful. So glad you made this video cos I needed UPDATING not ADDING row haha. Lifesaver!

Nice video for beginners like us. But at sometimes I feel scared also

Thanks a ton mate. It's only here that I found what I was desperately looking for in my use case

Great.. thanks a lot brother

Thanks Alireza, that was really informative.

Very clear explanation with example.. 👍🏻

Thank for share you knowledge it saves me a lot of time.

Hello Alireza, 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.

Thank you! Well and clearly explained.

Hi .. Your videos are very informative and easy to understand even the complex concepts. I have an REST API which gives JSON data i would like to convert into an excel file. Later i would like to sort the excel depending on one particular column value. Is there any way to convert as mentioned.