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
Answered

Extract data from Window UI Flow issue

(0) ShareShare
ReportReport
Posted on by 25

Hi,

 

I am trying to extract data from the window which has list of names in a single field (as seen in the screenshot). When I am using the action "Extract data from window" I am able to fetch the data. However, this data is not stored in the data table or a list though variable produced shows- 'The extracted data in the form of a datatable.'

 

Because of this I am not able to write this data into the excel sheet. Also, when I am directly selecting Store extracted data in Excel, only a part of the data is copied to excel and in a single cell (not as a table or on each row). I have also tried to create a new list so that whatever is stored in variable - "DatafromWindow," I could save them in a list. However, I am getting an error as- Variable 'DataFromWindow' must be a list, datatable or datarow.

 

Attaching the screenshots for reference. Could anyone please help me to understand how I can extract the data from a window wherein multiple values are stored in a single filed can be saved as a datatable or a list? and then add that data into excel?

 

Thanks.

Licensee5.jpgLicensee6.jpgLicensee7.jpgLicensee8.jpg

 

  • Highboy Profile Picture
    1,187 Super User 2024 Season 1 on at

    You can create a list by using the Split Action with DataFromWindow as input.

  • Anurag_R Profile Picture
    25 on at

    @Highboythanks for the suggestion. But, I have already tried split action. However, all the values are stored in a single row instead of multiple rows.

     

    Any other way around?

    Thanks

    Split actionSplit actionTextlistTextlist

  • Highboy Profile Picture
    1,187 Super User 2024 Season 1 on at

    Then it must be something else than a "New line" that seperates them...

  • VJR Profile Picture
    7,635 on at

    Its strange to see it is not working with the split on new line as per @Highboy's suggestion.

    Also please check if it is really a new line character. This can be checked in a hex-editor (like notepad++).

     

     

     

  • Verified answer
    Anurag_R Profile Picture
    25 on at

    @VJRthanks, I used action- Write text to file option. By this I am able to copy the names in notepad and then write it into excel sheet.

  • VJR Profile Picture
    7,635 on at

    Perfect. Thats the way to go.

    If your query is resolved you can close the thread. And if not feel free to share.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 211 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 190

Last 30 days Overall leaderboard