web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract data from wind...
Power Automate
Unanswered

Extract data from window ui element

(0) ShareShare
ReportReport
Posted on by 49

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

 

I have the same question (0)
  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Hi @dzek 

     

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

    Kaif_Siddique_0-1663353840616.png

     

    Regards

    Kaif

  • dzek Profile Picture
    49 on at

    Hi @Kaif_Siddique 

     

    i get this error with the DataGrid.

    Screenshot 2022-09-16 221020.png

     

     

     

     

  • dzek Profile Picture
    49 on at

    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 

  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

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

  • dzek Profile Picture
    49 on at

    @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.

    Screenshot 2022-09-16 223903.png

     

    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)

     

     

  • dzek Profile Picture
    49 on at

    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?

     

    Screenshot 2022-09-16 234620.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 785

#2
Valantis Profile Picture

Valantis 669

#3
Haque Profile Picture

Haque 563

Last 30 days Overall leaderboard