Unanswered

Flow to connect MS Form to Excel running extremely slow/failing tests suddenly

(0) Share

Report

Posted on by MISHI

I am completely new to POwer Automate. I made a flow to collect data from a MS Form to MS Excel. The Excel file has multiple formulas and is about 13MB in size (well below the 50MB max limit). The flow was working fine till yesterday but since today, it is extremely slow in adding rows to excel table or failing to run/test completely. Please advise.

Categories:

General topics

All responses (5)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey! If you have the trigger set to "When a new response is submited" and the only action you have is "Insert Row in excel" it shouldnt be slow
The problem might be in the formulas. What you can try to do is do that "formulas" in power autoamte. It would be easier

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!
MISHI 6 on at

Like
a
(0)

Report
Copy link

Link copied!

hI

Here are screenshots of the flow settings. The issue started after I started inserting formulas in excel that involved about 10000 rows. that caused the excel file size to reach 13MB. still it shouldnt cause the flow to break ideally. Can you help?
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Why do you have a for each?

Just 1 action "Add row" would work and you sue the fields that you get from the trigger

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!
MISHI 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your patient support.
I tried that way to.. the flow worked once (only partially). The second test has been running for over a minute now.. looks like its going to fail again.. sincerest apologies for being a complete noob in this. Can you please guide me on where I am going wrong?
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I dont have any excel BUT, as you can sse I can get stuff from the trigger. Just use that stuff that you can egt instead of sing a for each

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!