Unanswered

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

(0) Share

Report

Posted on by Cristinacn Microsoft Employee

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

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

kassie12345 10 on at

Like (0)

Report
Copy link

Link copied!

Exact same issue for me too!

Was this reply helpful? Yes No
Cristinacn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
enteire 23 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ashwanidv100 39 on at

Like (0)

Report
Copy link

Link copied!
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.

Re-Create the connector in parallel branch to check if that is working.
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.
Check excel table name and Columns as well.
Check which row the flow is trying to identify is there available in excel table or not.
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 !

Was this reply helpful? Yes No
Cristinacn Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
kassie12345 10 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RemcoV16 52 on at

Like (0)

Report
Copy link

Link copied!

Everything works fine for me now too

Was this reply helpful? Yes No
ashwanidv100 39 on at

Like (0)

Report
Copy link

Link copied!

Good to know all. That things are continue again.

Was this reply helpful? Yes No