Forum Discussion
SharePoint Calendar from ERP system
I am trying to import data from our ERP software to a shared calendar on SharePoint. The data is the delivery schedule. Dates may change for individual order and we need that to be reflected in the c...
Will users need to setup alerts on this calendar list, ex: when an event is added/modified? Will users sync this calendar to their outlook? If the answer is no, I would just scrap everything in the list each time I get an updated file and fill it with the new entries, because, what if you try to update a single entry, and the flow fails to run? You'll end up with an obsolete entry in the calendar list and never and will never get updated. However if you replace everything in the list, you can just run the flow manually and replace everything (that's in case the answer to the 1st two questions is "no").
I have made some changes and progress.
I now have the ERP software saving the files as .xlsx and running a macro to convert the data into a table.
I created a new flow with these elements. Excel online - Get The Tables > Excel online - List the Rows Present in the Table > SharePoint – Create Idem.
I created a list on SharePoint and added a Calendar View.
What I need now is to add something to the flow to delete items in the list before I create the updated items.