Answered

Missing records in excel

(0) Share

Report

Posted on by Emm4nuel

Hello

I am new at this, I hope you can understand me. We have an issue with a flow in power automate and Excel, let me explain it:

-We have a flow that reads a SQL SP. If we consult that SPin the SSMS, we get 2 records as result.

-I can see both records in the "output parameters" section in the flow.

-The flow sends an email with result. The result is included in an excel file.

-I open the excel, but I can see only one record, the other one is missing.

-I dont see any errors in the flow.

-A previous execution included the missing record (the information of that record was the same).

-The other executions (previous and pos) include all the records. We only had this issue with that execution.

Thank you in advance.

Categories:

General topics

All responses (7)

Answers (1)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can we please see a screenshot of your flow with the actions open?
Emm4nuel 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Rhia.

Thank you for your time. I hope I can explain this well:

This is the flow:

The first module use the SP in the database:

Then, we take the latest report and delete that file. These steps are not important: Then, we get the template for the report

Next step, we fill the template with the information:

And then, we send the email with the file attached:

I don't see errors in that execution:

And the flow is reading both records. This one is the missing record:

The flow is inserting the record in the excel file:

But we get only one record in the excel. We should get two.:

I checked the SP in the SSMS, I could see both records:

PD: Sorry, I had to block a few lines.
Verified answer

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Ah, I see - can you try something for me, just to see if it resolves the issue for now?

Add a delay of 30 seconds right after the "add row to Excel" action in your loop. I've seen a few reports of this issue, and sometimes that helps - sometimes it's permissions - sometimes it's duplicated files (ie, if there's more than one of the same name, that causes issues) - and sometimes it's just a service error.

Let's see if that helps and then move on to another option if not...
Emm4nuel 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Rhia.

The delay is already in action. The "add row" action is in the module "Apply to each 7" and then, we apply the delay.

Unfortunately, the user reported this problem late so the information has changed since then and I cannot validate that same run.

If you can tell me the other possible causes, it would be a great help and that would be enough.
Thank you very much for your help
Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

The delay is outside of the Apply to Each loop

It would need to be inside of it. The goal is to give Excel some time to confirm the addition of the previous data before moving to add the next data.

Did you check your files / permissions based on the other potential issues I mentioned?

R
Emm4nuel 10 on at

Like
a
(1)

Report
Copy link

Link copied!

My bad. Thank you Rhia. We added a new delay inside the loop:

Did you check your files / permissions based on the other potential issues I mentioned?

R
Yes, I did. I didn't see any issues regarding permissions or files. From what we have been informed, this was the only run where some information was missing.
Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

That's interesting - well, let us know how it goes on the next run, with the delay in here. It will take longer to run (of course), but if we're still missing rows then we know it's something more dastardly...