Skip to main content
Community site session details
Power Apps - Building Power Apps
Answered

Parsing an Excell file to get cells' values

Like (0) ShareShare
ReportReport
Posted on 10 Dec 2023 16:26:19 by 9

Hello friends,

 

It's been a while!

 

I am trying to build a powerapps application to which I load an excell file which is then stored in blob (content: appres://blobmanager/...........). After getting the excell file in the blob storage, I want to get cells' content of specific columns in the file and then store these cell's values in a collection (column1: cellvalue1, column2: cellvalue2 etc). Is this possible directly using JSON parson in power apps or some builtin actions of a power automate flow? 

 

Thanks in advance!

Regards

  • Verified answer
    SunilPashikanti Profile Picture
    731 Moderator on 10 Dec 2023 at 19:49:41
    Re: Parsing an Excell file to get cells' values

    Hi @sakura_san,

     

    It seems that there is no direct way to get the cell values from an excel file stored in Azure Blob Storage using Power Apps or Power Automate. However, there are some possible workarounds that you can try:

     

     

    Best Regards,

    @SunilPashikanti 

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete