cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Vipul97
Regular Visitor

Creating a sharepoint list using an excel file on PowerApps

I am trying to create an App which for which I want help with the following functionalities:

1) Creating a flow such that I am able create a Sharepoint list using the excel file which I have uploaded on the App.

2) Create a functionality which enables me to delete any pre-exisiting excel files in the specified document library on the Sharepoint.

Kindly help me out with the aforementioned asap. Thanks in advance.

1 REPLY 1
Dual Super User
Dual Super User

Re: Creating a sharepoint list using an excel file on PowerApps

Hi @Vipul97 

 

Step 1 would be to give the option to user in a PowerApps to add file (excel)

Netx step would be to post the file to Flow

https://www.youtube.com/watch?v=5XsWgVnR7SU&t=514s

 

Next step would be to first delete the existing excel file

You can use Get Items action to get all files in a document library in Flow

and then use Delete File to remove the file

 

Next step would be to post the new excel file to the lIbrary

Create file action

 

I do not have an exact example but the video above will help you post files to a SharePoint document library from PowerApps 

 

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

 

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Attending MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We're launching a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Emergency Response & Monitoring Solution

Emergency Response & Monitoring Solution

Microsoft has created a regional government emergency response and monitoring solution that is built on Power Apps and Power BI.

Top Solution Authors
Top Kudoed Authors
Users online (5,166)