Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Extract Data from Cells in Excel Worksheet

(0) ShareShare
ReportReport
Posted on by 252

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

  • AlexEncodian Profile Picture
    AlexEncodian 4,314 on at
    Re: Extract Data from Cells in Excel Worksheet

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

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Extract Data from Cells in Excel Worksheet

    HI @AlexEncodian 

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

  • AlexEncodian Profile Picture
    AlexEncodian 4,314 on at
    Re: Extract Data from Cells in Excel Worksheet

    Hi @Skybluekid 

    If your data is not in a table data type, then the native Excel connector can't help. What file type is your excel file?

    If its a CSV, you can use Encodian's Parse CSV action to get the CSV data as a JSON to use in your flow.

    If its not a CSV, you would first have to convert it to a CSV using Encodian's Convert Excel action. 

    We are working on a "Convert Excel to JSON" action however this is not currently available. 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard