Unanswered

Extract data from window ui element

(0) Share

Report

Posted on by dzek

Hey everyone, I'm new here and I'm trying to export some data to Excel from UI Element. Can anyone help me? I'm trying to extract this data like it is in an Excel file but i can't put as element any text. only the whole pane of the table. Screenshot 2022-09-16 211508.png

Screenshot 2022-09-16 212237.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

Hi @dzek

Are you able to capture the DataGrid ? Please refer the sample Contoso Invoicing.

Regards
Kaif

Was this reply helpful? Yes No
dzek 49 on at

Like (0)

Report

Hi @Kaif_Siddique

i get this error with the DataGrid.

Was this reply helpful? Yes No
dzek 49 on at

Like (0)

Report

It was a problem with my excel and now is working with DataGrid. With the other app it doesnt work. Can you help me? @Kaif_Siddique

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

are you still facing the issue ? shared flow image is small and error is not visible properly, could you share it again ?

Was this reply helpful? Yes No
dzek 49 on at

Like (0)

Report

@Kaif_Siddique the problem was with excel not launching but i figure it out.. the situation with my application and not with Contoso Invoicing is not working.

Error details:

Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Extraction failed (failed to get UI element) ---> Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.Exceptions.ElementNotFoundException: Exception of type 'Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.Exceptions.ElementNotFoundException' was thrown.
at Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.AutomationRuntimes.UIAutomationRuntimeBase.RetractElement(IntPtr windowHandle, String selector)
at Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.AutomationRuntimes.UIAutomationRuntimeBase.ExtractTextFromElementsInWindow(IntPtr windowHandle, String selector)
at Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Common.UIAutomationActionBase.PerformAutomation[T](Func`2 action, UIControl control)
at Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Actions.ExtractDataFromWindow.Execute(ActionContext context)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.UIAutomation.Actions.ExtractDataFromWindow.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

Was this reply helpful? Yes No
dzek 49 on at

Like (0)

Report

i have found a workaround but now i have another problem. When i extract them in excel i get the data duplicate in each cell. How can i prevent this to happen and get only one date in each cell?

Was this reply helpful? Yes No