Power Platform Community Forum Thread Details

So I've noticed a problem where Get first free column Excel-action gives me the following error:

This flow has worked for more than two years so something has changed recently about excel file reading. Any ideas?

Error msg:

Correlation Id: 092eb4c8-616d-40ab-ae56-33ee171d6985

Invalid forward reference, or reference to uncompiled type. (Exception from HRESULT: 0x80028029 (TYPE_E_INVALIDSTATE)): Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Failed to retrieve first free column/row. ---> System.Runtime.InteropServices.COMException: Invalid forward reference, or reference to uncompiled type. (Exception from HRESULT: 0x80028029 (TYPE_E_INVALIDSTATE))
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.GetProperty(Object o, String propertyName)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.GetFirstFreeColumnRow(Variant excelInstance, Variant& freeColumn, Variant& freeRow)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.GetFirstFreeColumnRow.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

Categories:

Power Automate Desktop