cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DomMB001
Helper I
Helper I

Sharepoint List creation

Hi,

 

I'm trying to create a scheduled flow. I want it to pull a table from an Excel file and create a Sharepoint List with all the rows. When the next schedule is due it should only load NEW data. Any help would be much appreciated.

4 REPLIES 4
RobElliott
Super User
Super User

@DomMB001 there's no action to create a list in SharePoint unless you use the paid-for Plumsail SP action. Without that you would need to have the list already created and then use the SharePoint create a new item action.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

@RobElliott sorry I meant "Create Item" I have the SP list already created. I want to be able to populate the list with new data daily so avoid uploading duplicates.

Hi @DomMB001 

 

Currently there is no way to identify the last modified or latest created row in Excel. To do this you can either add an extra column that stores the information of created/ modified time stamp and then based on the recurrence trigger, add filters to filter the latest data and create items in the SP list with that. 

 

One other way to do this would be keep deleting the rows from excel as soon as they are added in the SP list. Something like -> list excel rows, apply to each, create a new item, delete the current row. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Thanks, do you have a sample flow that I could see perhaps? @yashag2255 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,389)