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 / Uploading File to Shar...
Power Automate
Unanswered

Uploading File to SharePoint and Extracting Data from the uploaded file

(0) ShareShare
ReportReport
Posted on by 986

Hi everyone,
Initially for a registration screen which had 4 sections like Personal Details, Projects , Skills (3 sub-types: Primary Skill, Secondary Skill, Soft Skill) , Certifications. So to do this I had created different lists (for Personal details I am making use of Office 365 connector to fetch the required details: First Name, Last Name, Email, Phone) and then using the forms I am getting the user inputs with the help pf forms, this was working as expected. (For more details you can check the following : Query )  


Just to make things simpler I had a requirement wherein a button will be provided where the user can upload a file (mostly excel file) which will be have a defined template (that I have already fixed with the necessary columns and converted it into a table), for which I have created a flow wherein at start I am uploading the file from user's local system to a SharePoint Document library, then using the same file I am trying to extract the contents and send it back to Power Apps. The response (JSON) will be stored in a collection which I am showcasing in a gallery just to check if the data is retrieved properly or not.
The flow looks like:

Sidhant_02_1-1700214394958.png

 

(In the first two steps I am uploading the file to a SharePoint document library named DocumentUploads)
Once the file is uploaded, I want to make use of the same file to retrieve its content for which I am using:

Sidhant_02_2-1700214495887.png

Finally using HTTP response action, I am retrieving the data set in the variable in a particular schema (JSON format which is related to my dataset)

Sidhant_02_3-1700214583825.png


A sample file: (Data to be uploaded to SP will look like this)

Sidhant_02_4-1700214673284.png


In Power Apps: (I have added an Attachments control to upload files and a button which triggers the above flow with the expression)

ClearCollect(excel_Import, 
 storeFileSPImport.Run(
 {
 file: {
 contentBytes: First(SampleFile.Attachments).Value,
 name: First(SampleFile.Attachments).Name
 }
 }
 )
)

Here the excel_Import is the name of the collection in which I want to retrieved data from the file and 'sampleFile' is the name of the Attachment control.
So when I tried to execute it, I got the following:

Sidhant_02_5-1700214851805.png

 

Sidhant_02_6-1700214867656.png


If anyone has any idea about Importing data from a file into Power Apps, please do let me know and if I am missing anything.


Regards,
Sidhant.

Categories:

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 259 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 227 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 134 Super User 2026 Season 2

Last 30 days Overall leaderboard