Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Urgent help needed - error "item not found" at "create table" step

(0) ShareShare
ReportReport
Posted on by

I have an issue with the "create table" step in my flow, my flow is supposed to capture an email attachment which is "xlsx" file and create table in the file with certain range and transfer this table content into a sharepoint list.  The flow has been working well for the past few months, until 9.30am this morning (China timezone) it worked fine, but everything since then has failed, it's still not working so far.  I have no choice but to manually upload the contents into the sharepoint list now.  With the other descriptions above here, it seems something is wrong with either the Flow site setup or the server???  Hope this issue can be solved quickly, as manual work is a real pain! Thanks!!!

 

Here is the detail of it

Cristinacn_0-1625744719168.png

 

  • ashwanidv100 Profile Picture
    ashwanidv100 39 on at
    Re: Urgent help needed - error "item not found" at "create table" step

    Good to know all. That things are continue again.

  • RemcoV16 Profile Picture
    RemcoV16 52 on at
    Re: Urgent help needed - error "item not found" at "create table" step

    Everything works fine for me now too

  • kassie12345 Profile Picture
    kassie12345 10 on at
    Re: Urgent help needed - error "item not found" at "create table" step

    I raised a microsoft suppot ticket yesterday too and they confirmed that they had a global outage.

    They just emailed to say it's now been fixed.

  • Cristinacn Profile Picture
    Cristinacn on at
    Re: Urgent help needed - error "item not found" at "create table" step

    @ashwanidv100 Thanks for the reply. It turns out I didn't change anything or try any other solution from my end, but I did talk to the helpdesk and they raised a ticket for me with the SharePoint support team, then a support engineer called me to ask for the details of error and screenshots, an hour later the flow went back to normal.  Although this engineer claimed she did nothing from her end either, which makes this whole down-back process pretty weird, but it proves my theory - something must have happened at the server, not me or my users behavior, because we have been doing exactly the same thing for the past 4 months and everything just failed yesterday and came back today.  The only pattern I can probably see is: it was broken at around 10am (at UTC+8 time zone) yesterday, and went back on at nearly the same time today, so not sure what happened within these 24 hours.  

  • ashwanidv100 Profile Picture
    ashwanidv100 39 on at
    Re: Urgent help needed - error "item not found" at "create table" step

    This generally happens when your excel or flow get updated or for some reason the matching ids gets broken. 

     

    There are couple of ways to have a look to find the actual issue.

     

    1. Re-Create the connector in parallel branch to check if that is working. 
    2. If any other excel connector is working for the same table before this step, means this connector is not correct connected with excel table anymore.
    3. Check excel table name and Columns as well.
    4. Check which row the flow is trying to identify is there available in excel table or not.
    5. Run Test flow for new entry.

    I think these steps are always helps to find any error in power automate and especially while using excel connector.

     

    I can see that your 'Create Table' connector is indicating to find wrong file. Check the extension of your excel file.

     

    If this answer help you by any means, Please gives a thumbs up !

  • enteire Profile Picture
    enteire 23 on at
    Re: Urgent help needed - error "item not found" at "create table" step

    Issue that I'm experiencing is shown below. This only started happening this morning and is causing multiple flows to fail.

     

    enteire_1-1625757596726.png

     

     

  • Cristinacn Profile Picture
    Cristinacn on at
    Re: Urgent help needed - error "item not found" at "create table" step

    Bringing this to the top because many users are relying on this flow+power app to finish their daily work.  Hope the super users or admin can see this! 

  • kassie12345 Profile Picture
    kassie12345 10 on at
    Re: Urgent help needed - error "item not found" at "create table" step

    Exact same issue for me too!

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard