Can't get the updated excel file

(1) Share

Report

Posted on by TN-09101039-0

Hi there.

I'm very new in using power automate and currently creating a flow to update the excel row to another excel row and save under box.com.

Flow works ok, but somehow can only get the value from the previous test flow (from the file newly saved in box) and the current test value flow does not reflect.

Below is my flow.

Appreciate if someone can help me. The "update a row action" has the correct output, but the box connection "create file 1" has the data from the previous test.

I put the "delay 1" action (20 seconds) to ensure enough time for the update to be reflected before one drive's "get content' action, is this not enough?

Categories:

AI Builder

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi

Can you please restate again, its confusing. Please do it in a step by step and call out whats not working.

Example

I'm very new in using power automate and currently creating a flow to update the excel row to another excel row and save under box.com.

What does a flow to update the excel row to another excel row?

Its not clear, are you trying to take the value out of row 1 from Sheet 1, in Workbook/Excel File FOO and put it in Row 14 or SHeet 4 or Workbook/Excel file GOO?

Remember we cannot see anything but a picture. No values or shown, or a failure or an explanation of what Action you need changed etc.

Happy to help but need clearer details please and dont over explain, just clarify

Flow runs

Grabs file A

Updates File B

Upload to box.com

That's all I am looking for for myself

Was this reply helpful? Yes No
TN-09101039-0 12 on at

Like (0)

Report
Copy link

Link copied!

Dear @FLMike

Thank you for your guidance.

Let me try again to clarify the error.

Flow runs:

Get a row from Excel table 1 saved in one drive

Update a row in Excel table 2 saved in one drive to the row obtained above

Delay - 15 seconds

List rows present in a table 2 (Excel in one drive)

--- till above, output data returns correct updated table 2 value --

Get file content (table 2)

Create file in box

--- the file created in box has the old, updated table 2 value which was obtained by the previous test. This is the same every time the flow is tested but the value is always from the test one time prior to the current test.

I hope this makes sense.

Thank you so much for your assistance.

Was this reply helpful? Yes No
Suggested answer

TN-09101039-0 12 on at

Like (0)

Report
Copy link

Link copied!

I found out that excel connectors may be locked for updates or deletion upto 6min, so after extending the delay to 7 min. all worked fine.

https://learn.microsoft.com/ja-jp/connectors/excelonlinebusiness/

I will close the case now. Thanks for the support.

Was this reply helpful? Yes No