Unanswered

UPDATE excel com documento fechado

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Estou tendo problemas ao dar UPDATE em um documento excel, ele passa pelo comando, entende que esta com status alterado e vai para o proximo caso, mas quando eu paro a automação e olho no documento, ele esta com status inicial.

Quando roda com o documento excel aberto, ele consegue dar UPDATE normalmente.

Categories:

Power Automate Desktop

All responses (14)

Answers (0)

Sort by

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Use Bing translator and share query again.
VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Translation:

UPDATE excel with closed document

I am having problems when UPDATE in an excel document, it goes through the command, understands that the status is changed and goes to the next case, but when I stop the automation and look at the document, it is with initial status.

When it runs with the excel document open, it can UPDATE normally.
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you saving and closing the Excel instance in the end?

Please share screenshots of the flow and if you can mention the translated actions that would be great.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This robot was migrated from Winautomation to power, it worked correctly, but after the migration, it stopped working.
With the document open it does UPDATE, but closed it does not, this prevents the robo from working where it left off if it is necessary to stop.

Flowopen SQL connectionrun SQL statement
VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Could you share what you meant by Excel Open?

How did you keep the Excel open and run the query?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I kept excel open and followed run the SQL command
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

before opening connection to excel I opened the document to run with it open.
ThomasFonn 273 on at

Like
a
(1)

Report
Copy link

Link copied!

Not sure if this is helpful or even make a difference, but the Connection String site provides some insights into the connection string

The file format your are using is a .xls rather than .xlsx which may lead to some inconsistencies when using Extended Properties="Excel 12.0" rather than Extended Properties="Excel 8.0"

You could try to change the connection string, OR try "Save As" on the file and change the format of the file to a newer file format to see if it makes a difference.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

thank you very much, I will test and inform the result.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Winautomation had difficulties with the documents .xlsx, now with the migration to power automate, I do not think i have this problem.

I changed the document .xlsx, but still the same problem, what Extended Properties do I use for Office 365?

before that update has another one that works normally, but the one is still having problems.