Power Platform Community Forum Thread Details

Hello,

I was using a script that worked so far to refresh some Excels containing Power Queries.

The flow would open an Excel Instance, open the file in question, do the sequence CtrL+Alt+F5 to launch a refresh, wait, save and close.

Worked perfectly so far. Than I did the latest update of Power Automate (maybe the issue comes from here) and the flow that worked perfectly now no longer works :

ID de corrélation : bc20ccde-d848-4c16-9662-e03e08851cd2

Méthode introuvable : 'System.ValueTuple`3<System.String,System.String,Int32> Microsoft.Flow.RPA.Desktop.Modules.SDK.Extended.Types.UIControl.Parse()'.: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Méthode introuvable : 'System.ValueTuple`3<System.String,System.String,Int32> Microsoft.Flow.RPA.Desktop.Modules.SDK.Extended.Types.UIControl.Parse()'. ---> System.MissingMethodException: Méthode introuvable : 'System.ValueTuple`3<System.String,System.String,Int32> Microsoft.Flow.RPA.Desktop.Modules.SDK.Extended.Types.UIControl.Parse()'.
à Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.UIAutomationActionBase.ParseSelector(UIControl control)
à Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.UIAutomationActionBase.GetRuntimeElement(UIControl control, ElementRoute route)
à Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.UIAutomationActionBase.PerformLocalAutomation(Action`2 action, UIControl control, Boolean logAction)
à Microsoft.Flow.RPA.Desktop.Modules.MouseAndKeyboard.Actions.SendKeys.Execute(ActionContext context)
--- Fin de la trace de la pile d'exception interne ---
à Microsoft.Flow.RPA.Desktop.Modules.MouseAndKeyboard.Actions.SendKeys.Execute(ActionContext context)
à Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

Seems to be an issue with the steps to input Ctrl+Alt+F5, but i don't undersatnd why this suddenly happens.. Can anyone help ?

Thank you all !

Cheers,

PS : annnnnd of course that flow is ESSENTIAL to everything I'm doind 😉

Categories:

Power Automate Desktop