cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Flow to copy items from list to excel

Hey,

 

I built the following Flow:

  1. Get all items from a list
  2. For all items do:
    1. Copy item to Excel-Online-Sheet (all fields + additional field "date" with date = today())

image.png

 

The list contains around 500 items and the Excel-Online-Sheet around 50.000 rows.

 

During the last weeks the Flow did work quite unreliable: It took a long time (maybe understandable) but also every other day or so there appeared an error "Bad Gateway".

 

Any idea why this happens or how to prevent this?

 

Best regards,

Oliver

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Flow to copy items from list to excel

Hi @Oliver93 ,

 

Could you please share the screenshot of the configuration of the flow?

Does the flow would always run failed with gateway timeout error?

I suggest that you could contact Microsoft for any help with this issue since it couldn't be confirmed on my side.

Best regards,

Alice   

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

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: Flow to copy items from list to excel

Hi Oliver93, 

 

Regarding the time the flow is taking, did you saw a difference between the runs?

What is the frequency that you have this flow running?

 

Is it possible that it's running into throttling - what is the license you're using?

 

Regarding the bad gateway error, they usually are temporary or transient, please try to resubmit the flow.

If you are still having the issue, please try to recreate the flow to see if it will work.

Highlighted
Regular Visitor

Re: Flow to copy items from list to excel

Hey ancunha,

 

the flow runs daily and here you see the different execution times:

image.png

 

I already tried rebuilding the whole flow, that didn't change anything.

 

My best guess would be that the Excel file is too big, because I tried reducing it in another scenario and that helped. I'd do it here as well, but I need all the data in this one sheet.

 

I'm using the license Microsoft 365 Business Basis / Microsoft Power Automate Free

Highlighted
Community Support
Community Support

Re: Flow to copy items from list to excel

Hi @Oliver93 ,

 

What is the size of the excel file?

The maximum size of an Excel file that is supported by the Excel Online (Business) connector is 25 MB.

https://docs.microsoft.com/en-us/Connectors/excelonlinebusiness/

 

Best regards,

Alice   

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

Highlighted
Regular Visitor

Re: Flow to copy items from list to excel

Hey Alice,

the excel file is about 6mb, so that shouldn't be a problem.

 

Best regards,

Oliver

Highlighted
Community Support
Community Support

Re: Flow to copy items from list to excel

Hi @Oliver93 ,

 

Could you please share the screenshot of the configuration of the flow?

Does the flow would always run failed with gateway timeout error?

I suggest that you could contact Microsoft for any help with this issue since it couldn't be confirmed on my side.

Best regards,

Alice   

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

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (8,818)