Hello I try to extract entire html table from the web page but I got error like this
To elaborate I open one web page with power automate (save that link as %browser%) . Then I click on a hyperlink and go to another page which has the table I want to extract info from.
FYI: This is company data so the link in the next web page search bar can't be copy.
Also when I use live web helper to extract the entire table, all the infos in the table do appear but when I ran the flow I still got this error
Correlation Id: 4e6080f1-4e59-4f7b-ba96-40a64b51d19f
Data extraction element not found.: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Failed to extract data (web page error while extracting data). ---> System.Exception: Data extraction element not found.
at Microsoft.Flow.RPA.Desktop.UIAutomation.WebAutomation.Core.DataExtraction.LegacyExtractorBase`1.GetExtractionResults(Stopwatch stopwatch, Nullable`1 timeout)
at Microsoft.Flow.RPA.Desktop.UIAutomation.WebAutomation.Core.DataExtraction.LegacyExtractorBase`1.InvokeExtraction(Nullable`1 timeout)
at Microsoft.Flow.RPA.Desktop.UIAutomation.WebAutomation.Core.DataExtraction.LegacyExtractorBase`1.Extract(Nullable`1 timeout)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Common.DataExtraction.Engine.WebDataExtractionEngine`1.AttemptExtraction(ICollection`1 resultsList, WebActionRetryParameters retryParameters, Int32 attempts, Nullable`1 timeout)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Common.DataExtraction.Engine.WebDataExtractionEngine`1.<>c__DisplayClass4_0.<ExtractElementData>b__1(Int32 attempts)
at Microsoft.Flow.RPA.Desktop.UIAutomation.Core.Utilities.Clock.Execute[T](TimeSpan timeout, TimeSpan period, Func`1 action, Func`2 successCondition)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Common.ClockActionPeriodicRunner.Run(Func`2 func, TimeSpan pediod)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Common.WebPager.WebPageEnumerator.ForEachPage(IWebAutomationBrowser browser, WebPagerParameters pagerParameters, WebActionRetryParameters navigationRetryParameters, Action action)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Common.DataExtraction.Engine.WebDataExtractionEngine`1.ExtractElementData(IWebAutomationBrowser browser, WebPagerParameters pagerParameters, WebActionRetryParameters retryParameters, Nullable`1 timeout)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Common.Proxy.LocalWebAutomationRuntime.ExtractEntireHtmlTableFromWebPage(WebBrowserInfo webBrowserInfo, WebExtractionSelector tableSelector, IEnumerable`1 columnNames, WebPagerParameters pagerParameters, WebActionRetryParameters retryParameters, Nullable`1 timeout)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Common.Proxy.WebAutomationRuntimeRouter.Invoke(MethodInfo targetMethod, Object[] args)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Reflection.DispatchProxyGenerator.Invoke(Object[] args)
at generatedProxy_3.ExtractEntireHtmlTableFromWebPage(WebBrowserInfo , WebExtractionSelector , IEnumerable`1 , WebPagerParameters , WebActionRetryParameters , Nullable`1 )
--- End of remote exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Flow.RPA.Desktop.UIAutomation.Shared.Rpc.RpcDispatchProxy`1.GetRemoteResultOrThrow(ISerializer serializer, RemoteMethodCallResponse response, Type expectedResultType, Object additionalContext)
at Microsoft.Flow.RPA.Desktop.UIAutomation.Shared.Rpc.RpcDispatchProxy`1.Invoke(MethodInfo targetMethod, Object[] args)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Reflection.DispatchProxyGenerator.Invoke(Object[] args)
at generatedProxy_1.ExtractEntireHtmlTableFromWebPage(WebBrowserInfo , WebExtractionSelector , IEnumerable`1 , WebPagerParameters , WebActionRetryParameters , Nullable`1 )
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.WebAutomationRuntimeServiceProxy.<>c__DisplayClass11_0.<ExtractEntireHtmlTableFromWebPage>b__0(IWebAutomationRuntime s)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.WebAutomationRuntimeServiceProxy.ExecuteSafe[T](Func`2 action, TimeSpan timeout)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.WebAutomationRuntimeServiceProxy.ExtractEntireHtmlTableFromWebPage(WebBrowserInfo webBrowserInfo, WebExtractionSelector tableSelector, IEnumerable`1 columnNames, WebPagerParameters pagerParameters, WebActionRetryParameters retryParameters, Nullable`1 timeout)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.ExtractData.<>c__DisplayClass57_0.<Execute>b__4(IWebAutomationRuntime s)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.WebAutomationActionBase.PerformWebAutomationWithLogging[T](Func`2 action, WebAutomationRuntimeLogData requestData, Func`3 resultData)
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.ExtractData.Execute(ActionContext context)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.WebAutomation.Actions.ExtractData.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)