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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!