update columns from another excel

[Kamacete]

Hi,

I need to do something easy (I think), but I still haven't been successful.

I have an Excel with 5 columns and I want to get values ​​of 3 columns for another excel. This is what I had done.

thank you for your support

[ChristianAbata]

hi @Kamacete  you are doing well, just you need to add filter to get only the values that you want. Please try with adding a condition list rows present in a table to do the filter and then inside the yes part you can add that rows into your excel.

[Kamacete]

Hi,

Thank you for your support, could you please can give me some example?

br,

Rui

[abm]

Hi @Kamacete 

Please have look at my blog regarding how to filter Excel rows.

https://mydevexperience.wordpress.com/2019/09/25/microsoft-flow-excel-list-rows-present-in-a-table/

Thanks

[ChristianAbata]

@Kamacete  sure please see the exampel bellow

so as you see you can use a condition to filter the data you want to pass to another excel, in my case the data started with C, beouse you can't just define what rows you need to copy you need a condition to define that.

[v-alzhan-msft]

Hi @Kamacete ,

Could you please explain more details about your requirement?

You said that you want to update column from another excel and the flow you created in to add new rows from another excel table.

So please explain more details about your requirement, you could share the screenshot of the two excel table and share an example of your needs so we could better understand you and provide a proper workaround.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kamacete]

Hi,

First of all, thank you very much for your support. I tried but didn´t work.

What I need is: I have a file (test 1) with 5 columns where I put data constantly and I need to update another file (test 2) automatically per hour with all the information of 3 columns (columns 1, 3, 5).

[File Test 1]

[File Test 2]

After I tried the solution that you kindly give me, this is the result.

Body

{

  "status": 409,

  "message": "This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: 5ba31de0-326c-481e-9ee7-1160f8faff2a\r\nserviceRequestId: 8657b2f4-2a1c-4e34-be9e-eb580871957f;9e369805-3e7e-43d9-880f-976df888474a",

  "error": {

    "message": "This won't work because it would move cells in a table on your worksheet."

  },

  "source": "excelonline-ne.azconn-ne.p.azurewebsites.net"

}

thank you again

Br,

Rui

[ChristianAbata]

hi @Kamacete  could you please show as a complete screanshot of your flow?

[Kamacete]

sorry

🙂

[ChristianAbata]

hi @Kamacete  what you are doing is ok, just try clossing all the file if are open, and delete every data inside to leave the table in blank

[Kamacete]

Hi,

Alter deleted all data from the file "Test 1", the flow runs successfully but is I add some data in the first row the flow fails.

😞

[ChristianAbata]

mmm  @Kamacete  it looks like the file is corrupted.

I suggest you to create a new file, with a new table just the destination file.

[v-alzhan-msft]

Hi @Kamacete ,

Your flow is correct with no problem.

I'm afraid that there is any problem in your excel table.

Please take a try to create the new excel tables and then create a new flow, then run the new flow again to see if the issue still exists.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kamacete]

Hi,

As suggested, I create other files but get the same result.

😞

{

  "status": 409,

  "message": "This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: 6a606cba-b336-489b-9619-41af3f2af173\r\nserviceRequestId: c0d2e8e0-828e-4d39-8410-5d243afb0947;4fda442a-88fc-46ee-aaff-1f0d1d22519b",

  "error": {

    "message": "This won't work because it would move cells in a table on your worksheet."

  },

  "source": "excelonline-ne.azconn-ne.p.azurewebsites.net"

}

how can I send you the files?

thank you very much

[v-alzhan-msft · Accepted solution]

Hi @Kamacete，

I have made a test on my side and see a same post as yours, hope it could be your reference:

https://powerusers.microsoft.com/t5/Using-Flows/Microsoft-Flow-Error-409-Adding-row-into-a-excel-tab...

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kamacete]

Hi,

I'am the owner of the sharepoint, and if I didn´t have any values inside the file A the flow complete with success .

thank you for you support

Br,