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.
@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.
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.
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!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.