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

Sdílet
Vložit

Komentáře • 56

  • @willywortel4623
    @willywortel4623 Před rokem +1

    This is exactly where i’m looking for, thanks

  • @BorisDK1
    @BorisDK1 Před 2 lety +1

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

  •  Před 2 dny

    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

  • @anshukumari8982
    @anshukumari8982 Před 2 lety +1

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

  • @malchicken
    @malchicken Před 2 lety +1

    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 CZcams algorithm uses that to know what related videos to show to people. Thanks for all the great demos :)

    • @DamoBird365
      @DamoBird365  Před 2 lety

      Thanks for the awesome tip, will look into that.

  • @ardeykurniawan1916
    @ardeykurniawan1916 Před 2 lety +1

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

  • @Sese29yt
    @Sese29yt Před 2 měsíci

    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
    @amanraj3244 Před 10 měsíci

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

  • @DhanushMunasinghe2008
    @DhanushMunasinghe2008 Před 2 lety

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

  • @Jezerypamela
    @Jezerypamela Před 4 měsíci +1

    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
      @DamoBird365  Před 4 měsíci

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

  • @NishaGarg-sv8xw
    @NishaGarg-sv8xw Před 4 měsíci +1

    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
      @DamoBird365  Před 4 měsíci

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

  • @pf3020
    @pf3020 Před 2 lety

    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
      @alexferris5483 Před 2 lety

      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
      @Jezerypamela Před 4 měsíci

      any luck wit this? @@alexferris5483

  • @user-sg8nd8lw4c
    @user-sg8nd8lw4c Před 10 měsíci

    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
      @DamoBird365  Před 10 měsíci

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

  • @prithapoddar7299
    @prithapoddar7299 Před 9 měsíci +1

    the filter query is generating blank output. Can someone help

    • @DamoBird365
      @DamoBird365  Před 9 měsíci +1

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

  • @jibbsautomations
    @jibbsautomations Před rokem

    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
      @DamoBird365  Před rokem

      Hi Jeremy, I don't understand your question. Do you mean something like czcams.com/video/pwJ73jFEtDQ/video.html ?

  • @coryslip
    @coryslip Před 2 lety

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

    • @DamoBird365
      @DamoBird365  Před 2 lety

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

    • @coryslip
      @coryslip Před 2 lety

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

  • @VANDIK01
    @VANDIK01 Před 10 měsíci +1

    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
      @VANDIK01 Před 10 měsíci +1

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

    • @DamoBird365
      @DamoBird365  Před 10 měsíci

      @VANDIK01 brilliant 👍 thanks for letting me know.

  • @kiranrama3
    @kiranrama3 Před 10 měsíci +1

    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
      @DamoBird365  Před 10 měsíci

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

    • @kiranrama3
      @kiranrama3 Před 10 měsíci

      ​@@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: czcams.com/video/pwJ73jFEtDQ/video.html . 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
      @DamoBird365  Před 10 měsíci

      @@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
      @kiranrama3 Před 10 měsíci

      @@DamoBird365 I am trying to do exactly what you do in this video: czcams.com/video/pwJ73jFEtDQ/video.html , . 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
      @DamoBird365  Před 10 měsíci

      @kiranramachandran2103 you could just convert the csv to json.

  • @alanswidler6062
    @alanswidler6062 Před 2 lety

    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
      @Brazoul Před rokem +2

      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
    @freerangedingo Před 2 lety

    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
      @DamoBird365  Před 2 lety

      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
      @freerangedingo Před 2 lety

      @@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
    @lornarodriguez7492 Před rokem

    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
      @DamoBird365  Před rokem

      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
      czcams.com/video/mNwEk7hLdfE/video.html. 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
      @lornarodriguez7492 Před rokem

      @@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
      @DamoBird365  Před rokem

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

    • @lornarodriguez7492
      @lornarodriguez7492 Před rokem +1

      @@DamoBird365 Thank you

    • @lornarodriguez7492
      @lornarodriguez7492 Před rokem +1

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

  • @TCEI23
    @TCEI23 Před rokem

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

    • @DamoBird365
      @DamoBird365  Před rokem

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

  • @jallabalaram4331
    @jallabalaram4331 Před rokem +1

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

    • @DamoBird365
      @DamoBird365  Před rokem

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