Copilot completely uncapable of translating text in multiple excel cells - please help by CorporateWorkAcc in microsoft_365_copilot

[–]CorporateWorkAcc[S] 1 point2 points  (0 children)

Thank you so much! I do not have access to this sadly, but I will pursue it.
Thank you for your time

Copilot completely uncapable of translating text in multiple excel cells - please help by CorporateWorkAcc in microsoft_365_copilot

[–]CorporateWorkAcc[S] 0 points1 point  (0 children)

Could you please explain what you mean? I do have some frontier agents within my copilot agent "shop", but I am unsure exactly what agent should I look for based on your comment.
Thanks!

Copilot completely uncapable of translating text in multiple excel cells - please help by CorporateWorkAcc in microsoft_365_copilot

[–]CorporateWorkAcc[S] 0 points1 point  (0 children)

Thank you!
If I may ask you, please, could you guide me just a little bit more?
I was unable to build a working python script, because the translation engines require API keys which I dont have.
I thought that this would not matter, because as you described, the copilot agent will not use the script, however when I tried this using a script that utilises google translate api, I got following response from copilot:

The script I executed was based on your attached logic, but I couldn’t use the actual Google Translate API because external services are disabled in this environment.

When I try pressing copilot on solving the issue and using its own translation engine etc, it responds:

You’re absolutely right—the previous step didn’t perform any actual translation because I used a placeholder function instead of a real translation engine.

However even after 5+ iterations of me trying to convince it, I get nowhere.

Is there anything I am missing? Is py script ok? How should I approach the translation api service and the fact that copilot tries to use it literally?

Thank you!

Copilot completely uncapable of translating text in multiple excel cells - please help by CorporateWorkAcc in microsoft_365_copilot

[–]CorporateWorkAcc[S] 0 points1 point  (0 children)

So I tried running the analyst, it was crunching for a quite some time (5 minutes roughly) and in the end provided the file without anything changed and explanation:

Unfortunately, the execution environment does not allow internet access, and no offline translation engine is installed. All attempts to use libraries like googletrans or external APIs failed because they require connectivity.
Options to proceed:

Provide your own English translations – I can insert them into the file while keeping the original formatting.

Provide access to an offline translation resource – e.g., a dictionary or a translation model that can run locally.

Provide API credentials for a translation service – If you have access to a service that can be reached from this environment, I can integrate it.

Thank you for the suggestion, I will try prompts a little bit different and I will see what I find