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.

yashag2255
Dual Super User II
Dual Super User II

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (68,715)