cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Add New Row to Excel Table

Hello, this is my first post so please go easy! it's also my first attempt at an automated flow.

 

I have a stock value CSV sent to me daily via email - I have created a flow to save to a folder once delivered to my inbox

 

I then have a flow triggered when a file is created to get file content using path.

Below is an example of the CSV format

DanPData_1-1642756134253.png

Below is the Parse JSON created.
{
    "type""array",
    "items": {
        "type""object",
        "properties": {
            "Branch 1": {
                "type""string"
            },
            "Branch 2": {
                "type""string"
            },
            "Branch 3": {
                "type""string"
            },
            "Branch 4": {
                "type""string"
            },
            "Branch 5": {
                "type""string"
            },
            "Branch 6": {
                "type""string"
            },
            "Branch 7": {
                "type""string"
            },
            "Branch 8": {
                "type""string"
            },
            "Branch 9": {
                "type""string"
            },
            "Branch 10": {
                "type""string"
            },
            "Branch 11": {
                "type""string"
            }
        },
        "required": []
    }
}

 

This is where I hit a problem!

I add a new step to add a row to an existing excel table. When the flow is tested, it's successful, but it adds a row for each branch so the data has cascaded, and not entered on a single row.

 

For example, this is what I want happen.

DanPData_2-1642758219059.png

 

This is what happens

DanPData_3-1642758372096.png

 

 

 

  

2 REPLIES 2
Johnnyg
Community Support
Community Support

Hello Dan,

What's your table size? Have you input all field value in 'Add a row into a table' as below

Johnnyg_1-1642928781459.png

Johnnyg_2-1642928808733.png

Johnnyg_0-1642928612815.png

 

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi Johnny

 

The table is already created with previous days values on.

 

When I enter my first branch value I get 'Apply to each' ??

I think this is causing the data to cascade

DanPData_0-1642970619336.png

 

The above creates the below cascading line

DanPData_1-1642970886673.png

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (3,483)