cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Upload excel file to SharePoint from powerapp

Hello All,

 

I want to upload excel files to SharePoint library from power apps. I used 'Add picture' control in powerapp screen for file selection and a button to trigger flow.

 

while running the flow I could not find any binary data and the file uploaded in sharepoint is corrupted. Below is the snippet, please guide on resolving the issue.

 

App.JPG

 

Flow.JPG

 

Thanks,

Sujanakar Reddy

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Hey mate,

 

You're on the right track, but you just need to use the attachment control to get the content of the data in Base64. You can then pass this to flow and create a file in SharePoint using the Base64ToBinary() function.

To save me reinventing the wheel, here is an excellent video on how to do so: https://www.youtube.com/watch?v=3QaiM8SeWfM

View solution in original post

2 REPLIES 2
Highlighted
Helper II
Helper II

Hey mate,

 

You're on the right track, but you just need to use the attachment control to get the content of the data in Base64. You can then pass this to flow and create a file in SharePoint using the Base64ToBinary() function.

To save me reinventing the wheel, here is an excellent video on how to do so: https://www.youtube.com/watch?v=3QaiM8SeWfM

View solution in original post

Highlighted

Thank you Jacob, you guidance saved my day.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,247)