cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AdamB1
Level: Power Up

Populate custom list from Excel spreadsheet

I see the need for copying or populating SharePoint custom list from Excel spreadsheet. There should be a function in sharepoint to "Import data" from excel or any othere data source.

 

Thanks

4 REPLIES 4
Super User
Super User

Re: Populate custom list from Excel spreadsheet

HI @AdamB1,

 

I think you don't need Flow for this. Simply use Quickedit. Then use copy/paste to populate the list from Excel to SharePoint lists. You will need to make sure that your column orders in both SharePoint and Excel match.

 

QuickEdit.PNG

AdamB1
Level: Power Up

Re: Populate custom list from Excel spreadsheet

Thanks, I just did that it worked fine with few issues. It only works from IE. I was trying before using Chrome and it didn't work. I agree with you, I don't think the need is for Flow. it's more for like a feature in SharePoint list just similar to "Export to Excel" button.

Timme
Level: Power Up

Re: Populate custom list from Excel spreadsheet

This only works from IE. Even the MS Edge browser is a no go. Unbelivable!

Community Support Team
Community Support Team

Re: Populate custom list from Excel spreadsheet

Hi @ AdamB1,

 

I have made a research on my side, When I Quickedit the list in sharepoint, use copy/paste to populate the list from Excel to SharePoint lists, the operation would works well with IE, and wouldn’t work with Chrome and MS Edge.

I would post this issue to my product team, if the issue is solved, I will reply here.

 

 

Regards,
Alice Zhang

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,674)