web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / When an excel file is ...
Power Automate
Unanswered

When an excel file is added to sharepoint doc lib, excel connector throws error

(0) ShareShare
ReportReport
Posted on by 613

Hi,

I have a flow where when an excel file is added to sharepoint doc lib, excel connector throws error.

 "body": {
        "status"404,
        "message""No table was found with the name '{B83DBAF7-7EF2-4853-8012-462DD3A39AB3}'.\r\nclientRequestId: 9078825e-6cbf-470f-b190-beecae36a9ff\r\nserviceRequestId: 0dcc2c52-d60c-41bf-bf6b-0dff55fdcc47",
        "error": {
            "message""No table was found with the name '{B83DBAF7-7EF2-4853-8012-462DD3A39AB3}'."
        },
        "source""excelonline-sea.azconn-sea.p.azurewebsites.net"
    }
 
I have configured a workflow to fetch an email from outlook inbox and update the existing file in the sharepoint doc lib. The file gets updated in the checkout state,  but my second flow where when an item is added to the SP doc lib it should list rows in excel which is not happening:
Teresa24486_0-1633451113681.png

Please advise.

Categories:
I have the same question (0)
  • dbro Profile Picture
    194 on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    @Teresa24486, It sounds like the List rows present in a table action may not be finding the table name in the newly added excel doc.  Does the excel file you added have the exact same table name as the action shows?  I think it must in order for it to work properly.

    2021-10-05_10-01-49.jpg

  • Teresa24486 Profile Picture
    613 on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi,

    so my flow works in a way that the excel sheet is automatically added to the SP doc lib through a flow, after which the second flow runs, so in this case the excel connector doesn’t detect the table field of the file automatically. Can u pls advise.

  • dbro Profile Picture
    194 on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Is the file name and table name always the same of the newly created file? Is it possible o make it such?

  • v-LilyW-msft Profile Picture
    on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi @Teresa24486 

    Please take a try to add Get Table action, then replace the table name with Table id.

    vLilyWmsft_0-1633484994518.png

    vLilyWmsft_1-1633485005489.png

    Hope the content above may help you.

    Best Regards

    If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Teresa24486 Profile Picture
    613 on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi @dbro,

    The excel file name is exactly the same, but I think when the new file is created the table name changes, the custom value is pre-defined this way already.

    Teresa24486_1-1633507793460.png

     

     

  • Teresa24486 Profile Picture
    613 on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi @v-LilyW-msft,

    I tried the steps you suggested and here is the error :

    Teresa24486_2-1633509341318.png

     

  • Teresa24486 Profile Picture
    613 on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi @v-LilyW-msft,

    I tried the steps you suggested and here is the error ; please advise.

    Teresa24486_0-1633598254165.png

     

     

     

  • v-LilyW-msft Profile Picture
    on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi @Teresa24486 

    From your output, the value of Get tables is empty.

    Please make sure there is a Table in the added excel.

    This is my test results.

    vLilyWmsft_1-1633599156440.png

    Best Regards.

     

  • Verified answer
    abm abm Profile Picture
    32,856 Most Valuable Professional on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi @Teresa24486 

     

    After the trigger add a delay for a minute or so. If not you might get resource not found error. Then use Get Tables and list rows present in a table. This should work if you hardcode all the path by browsing and set the filename and path. 

     

    If you want to make it dynamic (Excel file name and table) please have a look at this blog by Josh Cook.

     

    Get tables – Flow Alt Delete – Josh Cook [Microsoft MVP]

     

    Thanks

  • Teresa24486 Profile Picture
    613 on at
    Re: When an excel file is added to sharepoint doc lib, excel connector throws error

    Hi @abm

    I will check this out and give you an update. The error for the excel table isnt there, but the create condition did not work as expected. I had a few new records on the excel sheet which did not get updated on the SP list. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard