How to update Excel sheets from Power Automate - Ultimate guide
Вставка
- Опубліковано 7 вер 2024
- In this video we update an Excel table and we cover all the weird things that Excel and Power Automate throw at you when you try to do it.
Learn Power Automate expressions:
• Learn Microsoft Flow E...
Discount coupons for my courses on Udemy
sslwsh008.secu...
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb
Really appreciate how you make your videos practically from actual user problems. Very valuable content.
Thank you Alireaz, you are amazing and great value add in my skills.
Love it. I've been learning from you for over three years ❤
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, Alireza! Good stuff! Now I can stop pounding my forehead against the desk.
I love the way you show us step by step, even from the mistake. Respect! and Subscribed to you channel!
Thank you, Alireza! Great content! I'm learning so much!
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.
Thanks a ton mate. It's only here that I found what I was desperately looking for in my use case
Thanks this was super helpful. So glad you made this video cos I needed UPDATING not ADDING row haha. Lifesaver!
Very clear explanation with example.. 👍🏻
The video that I saw looking for, thanks pal!!!!
Thanks Alireza, that was really informative.
still a great video - thank you!
Thank you for your amazing and valuable sharing!
That's was exacly what I looking for. Thank you]!
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. 😄
Great info here
Thank you Alireza, much appreciated!!
Great video! 👍 *Thank you very much!* :)
Thank you very much ?
Can you also refresh an external data source (power query) in an excel sheet using power flow?
Did you get it?
Yes
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?
Thanks for Sharing. Would have taken me hours trial and error.
Thank for share you knowledge it saves me a lot of time.
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
Is it possible to extract the data from forms.
So that the forms document is the trigger function?
BTW. Great Video!
Fantastic content! Congrats
brilliant!!
Thank you! Well and clearly explained.
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.
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 !
Hi .Can you create a video how to combine excel files using power automate and load back to share point
You should also check the Udemy courses by Alireza. Really awesome!
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?
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
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
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?
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 ?
Great.. thanks a lot brother
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.
Instead of ID column which contains integers, could we use the Name column (text) as the key column?? Will this work??
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.
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 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?
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?
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.
I have a question, how I can a make a flow to Update the entire Excel sheet from the Excel query
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?
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
Nice video for beginners like us. But at sometimes I feel scared also
Hi. With Flow, how we can get flow to increment the ID by 1 each 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.
For part one watch this video
ua-cam.com/video/pdmOekp-4sc/v-deo.html
And this one for part 2
ua-cam.com/video/yLBohC1Rw00/v-deo.html
Then let me know where you need help :)
Thank you for replying! Will check it out. I appreciate the feedback and content.
My man, I am tired too. I'm going to bed now. I'll think about this more after a good night's sleep.
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.
Good enough ?🙂
ua-cam.com/video/JVDDKsboOks/v-deo.html
@@AlirezaAliabadi I followed the video and converted to csv but i would like to convert it into excel. Is it possible to convert JSON to excel or csv to excel. Thanks in advance
@@Reddy-by9wf
1. Create an Excel file and create an empty table inside it with the columns you need and save it somewhere (SharePoint/OneDrive) as template
2. Every time you run the Flow, make a copy of your template in your target destination.
3. Add JSON array items to the table using "Apply to each"
@@AlirezaAliabadi thank you so much for the info. Your video on parsing JSON to CSV is very informative. Can You please explain us with an example / steps of how to parse JSON to excel / CSV to excel. It would be really helpful for novice like me.
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
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?
The main thing is that when we work with Power Platform in general, we are limited to the connector functionality.
So far, I don't know a way to read the macros, but there is a good chance we have it in the future.
@@AlirezaAliabadi Thanks a lot for your timely reply
I find it changes but anything reading from it doesn't get updated
I dont uderstand how to update row in any Excel file. Not specific. If i want apply one rule for all files un library?
how to automate refresh date on excel
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
Yes 😊
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 :-(
Need to update and/or create many rows in Excel?
Try Excel batch actions in Power Automate:
ua-cam.com/video/HiEU34Ix5gA/v-deo.html
way too complicated for simple flow