web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
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.

I have the same question (0)

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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 535 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 348 Moderator

#3
developerAJ Profile Picture

developerAJ 262

Last 30 days Overall leaderboard