Heavy Excel file in Power Automate flow

Like (0) Share

Report

Posted on 29 Jan 2024 07:03:44 by AK989

Hello guys,

I am just wondering is there any solution to optimize the Excel file that is a part of Power Automate flow.

My flow consists of a few Compose actions to extract information from email and add a row in Excel file which is located on SharePoint. Since the Ecxel file contains a lot of sheets, formular and data, the flow just times out and ut doesn't work pretty much. Could you please help with advise.

Thank you in advance.

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-mengmli-msft on 29 Jan 2024 at 07:21:10

Like (0)

Report
Re: Heavy Excel file in Power Automate flow

Hi @AK989 ,

Are you referring to the fact that a separate "add a row" action times out? I'm afraid there's no way to improve the efficiency of an action at the moment, as opposed to reducing the number of apply to each in the flow to increase the speed of the flow, because adding a row is a necessary step in your flow. I recommend that you increase the run timeout limit for your actions.
I recommend you increase the Duration of Timeout. Following are few examples.
1 Month -> P1M
1 Day -> P1D
10 Minutes -> PT10M
10 Seconds -> PT10S
1 hours 30 mins -> PT1H30M

Best regards,
Rimmon

Was this reply helpful? Yes No
AK989 24 on 30 Jan 2024 at 07:12:24

Like (0)

Report

Re: Heavy Excel file in Power Automate flow

Thank you for the reply

Was this reply helpful? Yes No
AK989 24 on 30 Jan 2024 at 07:13:21

Like (0)

Report

Re: Heavy Excel file in Power Automate flow

Unfortunately, it's a corporate account and I don't have access to encodian. It seems pretty cool though.

Was this reply helpful? Yes No