cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ameyers_MSFT
Microsoft
Microsoft

Excel connections to OneDrive are highly unstable

I'm having an extremely difficult time with connections to an Excel file on my OneDrive. When I try to set up a new flow, I usually get a "Invalid character" error when trying to pick a table for an Insert Row action. When I open one of my existing flows, it takes forever and almost always when it comes up, the Excel action has a "Network request failure" error on it (or sometimes "Failed to fetch: GetTable").

 

I think this got a lot worse recently as I had some trouble but not nearly this much when I first set up some flows a couple weeks ago.

 

Here is one of my flows with this problem:

https://flow.microsoft.com/manage/flows/be0c256a-4e53-46ba-96fe-9925f145f361

 

(Ironically, I got the following when trying to post this message:

There was an error while attempting to post your message. Try again in a few minutes.

Sigh...)

6 REPLIES 6
v-yamao-msft
Community Support
Community Support

Hi Ameyers,

 

For “Invalid character” error, in your new flow to get tables or insert row, what properties did you set? To reproduce this issue, please provide a screenshot of your flow.
For “Network request failure”, this error occurred when you opened existing flows, were these flows all having connections to OneDrive? Or when you opened flows with no connection to OneDrive, did this error occur?


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Here's a screenshot of my flow for the "Invalid character" issue:

Invalid character screenshot

 

Here's the network request failure -- it only happens when opening a flow with OneDrive Excel connection:

Network request failure screenshot

Let me know if some info from a Fiddler trace would be helpful.

Hi Ameyers,

 

Thanks for your screenshot. I created a flow “when a new tweet is posted, insert row to Excel in OneDrive”, I could select the Table name. so make sure you had formatted your Excel sheet as a table. This flow ran and rows were inserted to my Excel sheet.

insert row(table name wiht path).PNG

                                    

For your second flow, I created a flow with “when a new tweet is posted, get tasks in Wunderlist, with an action, if yes, insert rows to Excel in OneDrive”.  I can also select the Table name and the flow worked well. Then when I opened the flow, just as you said, it took a long time and an error ”Network request failed” occurred. However, when I tried to open it again, sometimes it can also be opened quickly and no error occurred.

22222222222.PNG
 

You could use a Fiddler trace to capture logs for this issue to get some information and check if your Network works well.


Best regards,
Mabel Mao      

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Let me first reiterate that both of these issues are occur intermittently (although they occur about 80% of the time or more for me). My table is formatted correctly in Excel and occassionally it works -- in fact, the first time I tried this morning it worked but then the next two times (with the same file) it did not work.

 

I'm using Microsoft Corpnet so network connection should be fine. In any case, Flow shouldn't be so dependent on the network connection -- good retry logic is expected in a web app.

 

Here is a failing request/response for the first scenario (the Invalid character -- looks like it is "invalid character" because the response is HTML instead of JSON):

 

 

Link to request txt

Link to response txt

Anonymous
Not applicable

I just want to reaffirm that OneDrive connections are almost useless. Their failture rate is easily 80% or more. It's completely unreliable.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,987)