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 Cell...
Power Automate
Unanswered

Extract Data from Cells in Excel Worksheet

(0) ShareShare
ReportReport
Posted on by 262

I have a flow where the trigger is an order is placed in a folder on Sharepoint. 

What I would like to do is extract certain aspects of the order, ie certain cells(no tables in the files), and use that information to update a table of all the orders.   From what I researched, the only thing that could this is AI Builder, or am I missing something?

 

If not if I was create a table in the order form, which populated with the information I need, is there a way to look at the same table in each new file that is submitted, bearing in mind that the file name will always be different?

 

Thanks in Advance

Categories:
I have the same question (0)
  • Skybluekid Profile Picture
    262 on at

    HI @AlexEncodian 

    It is just a normal xlsx file. There are not any tables in the file that I can use.

  • AlexEncodian Profile Picture
    4,409 Moderator on at

    @Skybluekid then you could convert to CSV and Parse the CSV as described above.

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard