Add a Table to an Excel File - Save Email Attachment - Power Automate

[@BorisDK1]

The Filter... This is what I was looking for! Thank you!

[@willywortel4623]

This is exactly where i’m looking for, thanks

[@pthapa55]

Thanks for bringing this video, awesome tips that is exactly what I am looking for however; few questions. 1. How to save the office script and where to save it in order for me to use it in Power automate? 2. I have email attachments coming with multiple tabs (sheets), how can I save multiple sheets to table using Office Script? Can you please share one example script for multiple sheets. Thank you very much.

[@anshukumari8982]

This is amazing. You always provide a great solution. Thanks for such great videos!

[@malchicken]

Great video, very helpful :). To help spread the word of your channel I’d recommend adding other suggested/related channels to your profiles channels page. I think maybe KZbin algorithm uses that to know what related videos to show to people. Thanks for all the great demos :)

[@DamoBird365]

Thanks for the awesome tip, will look into that.

amazing one, thank you! do you know how I can save an XLS directly as XLSX without having to save it as XLS first and then open it and save it as XLSX again? because this way it creates a corrupted file, I makes me do the XLS and then XLSX to work

[@ardeykurniawan1916]

Mantap suhu 🙏 In Indonesian its mean : very nice teacher 😁

[@DamoBird365]

Thank you very much 😍

[@Sese29yt]

Hey, question - will this script also work when transferring a table from a specific sheet from an onedrive file to a specific sheet in a sharepoint file? I'm referring to your other video - where you showed how to save a csv file and use the script to convert the file to XLSX (huge thanks by the way - great video

[@amanraj3244]

Hi, please guide if the excel file have multiple sheets.

[@manjulmishra990]

Cannot read properties of undefined ( reading ‘getusedrange’)

[@DamoBird365]

I don’t recognise the error. You could report it on the forum with screenshots and I’m sure folk will get you up and running.

[@DhanushMunasinghe2008]

WOW! Great video, enjoyed it a lot, Keep on Creating

[@DamoBird365]

Thanks Dhanush.

[@NishaGarg-sv8xw]

I am doing exactly same as you have done but the Excel file created seems to be corrupted as it gives file format or extension is not valid. The file opens fine in browser mode but not in app. But when I am using the file further in the flow it is not able to find table and throws error so could please help

[@DamoBird365]

I’m not sure. Maybe share the details on the forum powerusers.microsoft.com/

[@pf3020]

Thanks for the great video. In the last step to run the script - for new folks to scripts - where and in what format is the script stored so power automate can find it. e.g. if using an O365 group, documents folder in teams sp -- upload the script where?

[@alexferris5483]

Yeah, I'm having the same problem. I created the OneDrive for Business file first including the script but when I get to this step I can't find the script to select it? What piece of the puzzle am I missing?

[@Jezerypamela]

any luck wit this? @@alexferris5483

[@Jezerypamela]

for some reason i cant select Filter Array 'Body' as a paramenter for the Apply to each "Select an output from previous steps. I do see attachments and other values, but not the Body output.

[@DamoBird365]

I seem to remember that new designer has a bug. You can write body(‘filter_atray’) as an expression.

[@coryslip]

Hello, could you make video how to get excel attachment from email to sharepoint list?

[@DamoBird365]

As a list item attachment or by adding items to a list based on rows of the excel file?

[@coryslip]

@@DamoBird365 Like if getting a email that excel attachment has no table, add rows from excel to sharepoint list item.

[@RobertErhardt-j4b]

Hi, I get most of this, but I am not understanding where the Excel script resides? Is it in the inbound outlook file attachment?

[@DamoBird365]

The office script? It lives in OneDrive or more recently it can be stored in SharePoint.

[@jibbsautomations]

Hi Damien, following this set up myself, I am hoping to be able to send an email using dynamic content from the List Rows action, but because we have to use Id for File and enter a customer name for Table, I'm not sure how this would work. Any suggestions?

[@DamoBird365]

Hi Jeremy, I don't understand your question. Do you mean something like kzbin.info/www/bejne/pqitaGage6qnerM ?

[@VANDIK01]

Hello Damo, awesome video, can you help me with this error.....We were unable to run the script. Please try again. Runtime error: Line 15: Cannot read properties of undefined (reading 'getUsedRange') clientRequestId: 2fe1cf61-39bc-4f7c-852c-de92a8ada9e1 sometimes thanks in advance.

[@VANDIK01]

My bad, I check the sheet name from the source file and it works, thanks Damo 👋

[@DamoBird365]

@VANDIK01 brilliant 👍 thanks for letting me know.

[@prithapoddar7299]

the filter query is generating blank output. Can someone help

[@DamoBird365]

conditions on strings are case sensitive - so you might need to check that?

[@kiranrama3]

When I test the flow, everything runs successfully, but the Excel file uploaded to sharepoint does not contain any tables or the data from the csv file in the emial at all. Instead there is just one line at the very top with a bunch of numbers and letters. Any suggestions on where I could be going wrong?

[@DamoBird365]

No idea if I’m honest. You need to look back at the history to try and understand why.

[@kiranrama3]

​@@DamoBird365 I was able to get this to work, but am having one more issue. My goal is to combine this automation with what you have demonstrated in this video: kzbin.info/www/bejne/pqitaGage6qnerM . I am trying to transform a file from csv to xlsx with table included, and then use that new excel file to filter data/ create sub tables to be sent to various people. I have successfully followed and created flows for both videos individually, but am facing many roadblocks when trying to combine the two. Do you have any videos discussing this or any advice? Thanks so much, your videos are a lifesaver.

[@DamoBird365]

@@kiranrama3 are you trying to turn an existing excel file into multiple excel files and email them to separate recipients? Presumably based on a filter and without using office scripts?

[@kiranrama3]

@@DamoBird365 I am trying to do exactly what you do in this video: kzbin.info/www/bejne/pqitaGage6qnerM , . I would like to create individual HTML tables based on an excel file exactly how you describe in the linked video. However, instead of selecting an excel file from onedrive, I would like to use the excel file I created in sharepoint through this flow of converting the csv file to excel and adding a table, the process detailed in this video. Combining the two flows, however, has brought many errors/problems

[@DamoBird365]

@kiranramachandran2103 you could just convert the csv to json.

[@alanswidler6062]

Even when I use the method outlines at 7:00 - to get the metadata using path and then pass that ID to the list rows present in a table - It still cannot "see" the tables present in my file. What am I doing wrong? (I thought there might be a difference between oneDrive and sharepointe so I tried it with both and both run into the same issue)

[@Brazoul]

Hi Alan, a workaround i have found is to initialize a variable with type string and have the value be the name of your table

[@freerangedingo]

I am working thru these steps and in Create file I keep getting an error when trying to open the uploaded file that 'Excel cannot open the file xx because the file format or file extension is not valid.' Any suggestions? The file name is 01-20-2022GardendaleCDP.xlsx. I mention this because my first attempt had the date with "/" and Excel doesn't like that. My original attachment was also a .xls file not .xlsx, but then I replace it with a .xlsx file to eliminate that as a problem and I still get the error. And just to be clear, a file is being created but I cannot open it. I also tried creating a CSV. I could open that but it was jibberish. Thanks in advance.

[@DamoBird365]

Are you using an email attachment? Possibly a problem with you file content expression? You can provide more detail on the forum on my site or try the MS forum powerusers.microsoft.com/

[@freerangedingo]

@@DamoBird365 The problem was with the trigger. I was reusing a trigger. When I stopped reusing the trigger it worked just fine. Annoying but....

[@lornarodriguez7492]

Hi, Do you have a video that could explain step by step a flow like this one but for the file to be overwritten in Microsoft teams. Same logic, email is received containing an attachement and the information in the attachement needs to be saved in the same file all the time that will live in Teams. Also i was checking on my ends about the Office Scripts, but i did not find anywhere a way to add this into Excel, Any help on this would appreciate it as well. Anyone can comment.

[@DamoBird365]

Hi Lorna, Office Scripts is something that can be disabled by your IT. If the automate tab isn’t visible, it’s disabled ☹️ you could look at the Graph API kzbin.info/www/bejne/o3_adp5tnbGXnKc. By overwrite, do you mean overwrite the file or the data within the file? You’ll always have to save the outlook attachment to access the data but the process of overwriting the file vs the content of the file will be different. What’s the use case? You can also ask on the forum powerusers.microsoft.com/

[@lornarodriguez7492]

@@DamoBird365 i was afraid that was the case TT_TT .. The file i have with the table format will be living in Microsft teams, when i receive the email with the attachement, this attachement will be in an Xlsx file but the information is not set as a table, so i want the content to be overwritten in the Teams files evertime i get this email with the no table excel file. i need the information to be updated in teams everytime this email comes in... I found an option for this, but its for one drive, im having a really hard time finding one that will work with microsoft teams.

[@DamoBird365]

@@lornarodriguez7492 Teams is SharePoint but I think the forum is a better place to discuss this one.

[@lornarodriguez7492]

@@DamoBird365 Thank you

[@lornarodriguez7492]

I got it to work now, and its awesome! You are great! Kudos to you on this video.

[@TCEI23]

Why won’t it save an an excel in my SharePoint library?

[@DamoBird365]

Very hard to offer any advice with additional info. You might want to ask on the official forum powerusers.microsoft.com/

[@jallabalaram4331]

Hi Any One Have Idea How to append Excel tables side by side in power automate @DamoBird365

[@DamoBird365]

What do you mean side by side? Are you trying to join tables in separate files based on a key value?