Excel Connector not finished before next step

(0) Share

Report

Posted on by BusyIntelligence

321

Hi, hope you can help me with this thing that I try to handle for months now.

I have a Flow that fills an Excel file with data returned by an API.

Results are added to a table in the Excel file on OneDrive for B.

After that I send an email with that file as attachment.

But, I notice the email is always(!) allready sent while the Excel connector is not finished.
So, the Excel file should contain for example 50 rows, but the file received in the mail only has 30 rows, or sometimes 48, sometimes just 20. When checking the Excel file on OneDrive, it is okay. It's just that the email step in the Flow (or the Logic App, tried that too) is fired too soon.
It runs fine when I add a delay of about 10 seconds between the steps, but prefer not to do that.

Also tried to first copy the Excel file, but then the copy also has not all rows.

Someone had this same issue and tips on how to cope with it?

Kind regards,

Maurits

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Maurits

Could you post your flow screenshot?

Thanks

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Maurits ,

Could you share a screenshot of the Flow configuration? What is the trigger you are using?

From your description, it seems that Excel Online's automatic save mechanism triggers Flow.

Although the data is not completely recorded in the Excel file, Excel online will automatically save the file within the specified time, which may trigger a Flow that uses When a file is created or modified as a trigger.

If this is the case, it is recommended that you use Recurrence as the trigger, then run Flow once a day to get the data contained in the Excel table and send an email.

Best Regards,

Was this reply helpful? Yes No
BusyIntelligence 321 on at

Like (0)

Report
Copy link

Link copied!

Hereby I try to be more clear, and added a screenshot.
In picture below I show what happens when using Excel on OneDrive.
I also tried Excel on Sharepoint.
I also tried an Logic App instead of Flow and even created a flow not using the Excel connector, but the graph api's.
All results were the same.
In short: when adding rows to an Excel file in a Flow step, the step returns succes while it's actually not finished yet (maybe due to caching or so).
When adding a delay step between the steps sometimes the results are fine. In this example I receive 37 records, then a delay of 20 seconds seemed to work. But when receiving 100 records, the delay of 20 secs is way too short, it should at least be a minute as far as I noticed when testing.

Was this reply helpful? Yes No
BusyIntelligence 321 on at

Like (0)

Report
Copy link

Link copied!

@PieterVeenstra Hi Pieter, I've used your Excel connector blog posts while creating this flow.
Do you know how to solve this?
Kind regards, Maurits!

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Maurits ,

Maybe you could set Apply to each and add Degree of Parallelism to improve the efficiency of the action execution in Apply to each.

Best Regards,

Was this reply helpful? Yes No