I cannot get add rows to work with dynamically created Excel file from outlook

(0) Share

Report

Posted on by CU28011938-0

I am stumped and Google is uncooperative.

I am trying to add rows to a static Excel master file from a dynamically obtained Excel file from outlook.

I have been unable to append data to the master file. If I take the dynamic file and pretend it's static in another power automate i can list rows and then append to the master document with add rows. But if the dynamic file is newly created, it will not append to the master file. Flow is as below

Trigger-- new email

Apply to each

Get attachment

Create file

Create table

Get table

List rows from dynamic file

Parse json - to get column names

Apply to each

Add rows to table. -- I'm failing here too append data

I believe it has something to do with mapping the columns, but what I'm doing is failing.

Please help

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU28011938-0

It would help to see the flow please, the pseudo is nice and its accurate per se, but seeing the real thing is what we need. Also you say its fails, what is the error? Or is it running fine but just not outputting anything?

Can you please share so we can see a Flow run (not just the flow) so we can tell you what you are doing incorrectly

Thanks!

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

1 people found this reply helpful.

Was this reply helpful? Yes No
CU28011938-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@micheal e.gerneay

Yes, MS power automate has green check marks all the way down when tested.

Yes It is failing to add the rows from the email attachment to the final Excel document.

I'll get you some photos of the flow

Was this reply helpful? Yes No
CU28011938-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Attached is the flow. The parts json is the same step

image001.png
Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU28011938-0

So those are the actions but that doesn't show how they are configured, also still need to see the flow Run as mentioned, because you need to look at the data going in.

Everything being green doesn't mean much, without the metadat showing why its green (it had no data, would make it green), it wrote to a different location because its miss configured would show it as green too.

Need to look at the flow run itself, look at each action and look at the raw inputs and outputs so you can see exactly what it tried to do.

if your loop is actually looping, then it thinks its writing somewhere, but you can tell by looking at the Apply to each and go through by clicking < or > so how many iterations does it say its going to do in your flow run?

what file is listed, what table, does it show data IN the actual properties when it runs.?

Was this reply helpful? Yes No