Skip to main content
Community site session details

Community site session details

Session Id : 96vBLdRDofVXIS6Uuph4xf
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 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete