SharePoint Calendar from ERP system

%3CLINGO-SUB%20id%3D%22lingo-sub-1433708%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Calendar%20from%20ERP%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433708%22%20slang%3D%22en-US%22%3EWill%20users%20need%20to%20setup%20alerts%20on%20this%20calendar%20list%2C%20ex%3A%20when%20an%20event%20is%20added%2Fmodified%3F%20Will%20users%20sync%20this%20calendar%20to%20their%20outlook%3F%20If%20the%20answer%20is%20no%2C%20I%20would%20just%20scrap%20everything%20in%20the%20list%20each%20time%20I%20get%20an%20updated%20file%20and%20fill%20it%20with%20the%20new%20entries%2C%20because%2C%20what%20if%20you%20try%20to%20update%20a%20single%20entry%2C%20and%20the%20flow%20fails%20to%20run%3F%20You'll%20end%20up%20with%20an%20obsolete%20entry%20in%20the%20calendar%20list%20and%20never%20and%20will%20never%20get%20updated.%20However%20if%20you%20replace%20everything%20in%20the%20list%2C%20you%20can%20just%20run%20the%20flow%20manually%20and%20replace%20everything%20(that's%20in%20case%20the%20answer%20to%20the%201st%20two%20questions%20is%20%22no%22).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433677%22%20slang%3D%22en-US%22%3ESharePoint%20Calendar%20from%20ERP%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433677%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20import%20data%20from%20our%20ERP%20software%20to%20a%20shared%20calendar%20on%20SharePoint.%20The%20data%20is%20the%20delivery%20schedule.%20Dates%20may%20change%20for%20individual%20order%20and%20we%20need%20that%20to%20be%20reflected%20in%20the%20calendar.%20We%20have%20set%20up%20a%20report%20that%20runs%20every%2015%20minutes%20exporting%20data%20to%20an%20excel%20file.%20The%20data%20is%20not%20in%20a%20table%20format%20and%20is%20overwritten%20every%20time%20the%20report%20runs.%20The%20output%20file%20looks%20like%20the%20following.%3CBR%20%2F%3EBillToName%2C%20OrderType%2C%20SalesOrderNo%2C%20ShipExpireDate%3CBR%20%2F%3EJohn%20Dow%2C%20S%2C%203000859%2C%205%2F13%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203000900%2C%205%2F11%2F2020%3CBR%20%2F%3EJan%20Smith%2C%20S%2C%20300094%2C%205%2F13%2F2020%3CBR%20%2F%3EBob%20World%2C%20S%2C%203001194%2C%205%2F13%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203001900%2C%205%2F11%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203001901%2C%205%2F11%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203001902%2C%205%2F12%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203001903%2C%205%2F12%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203001904%2C%205%2F13%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203001905%2C%205%2F13%2F2020%3CBR%20%2F%3ESports%20Construction%2C%20S%2C%203001906%2C%205%2F15%2F2020%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20tried%20using%20Flow%2FPowerAutomate%20But%20I%20get%20lost%20when%20writing%20the%20data%20to%20a%20SharePoint%20list.%20I%20can%20export%20to%20CVS%20file%20using%20a%20batch%20file%20but%20I%20don't%20know%20what%20to%20do%20with%20it%20then.%20I%20am%20thinking%20if%20I%20know%20what%20kind%20of%20file%20a%20SharePoint%20list%20is%2C%20I%20could%20over-right%20it%20when%20a%20new%20file%20is%20created%20by%20ERP%20software.%20Otherwise%2C%20I%20would%20need%20to%20delete%20all%20events%20and%20write%20the%20new%20data.%20also%20need%20to%20save%20the%20SalesOrderNo%20column%20to%20the%20Title%20column.%20BillToName%20column%20to%20the%20Location%20column.%20ShipExpireDate%20column%20to%20Start%20Time%20column.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20ideas%20on%20how%20to%20get%20this%20done%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1440508%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Calendar%20from%20ERP%20system%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440508%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F532869%22%20target%3D%22_blank%22%3E%40derhallim%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20have%20made%20some%20changes%20and%20progress.%3CBR%20%2F%3EI%20now%20have%20the%20ERP%20software%20saving%20the%20files%20as%20.xlsx%20and%20running%20a%20macro%20to%20convert%20the%20data%20into%20a%20table.%3CBR%20%2F%3EI%20created%20a%20new%20flow%20with%20these%20elements.%20Excel%20online%20-%20Get%20The%20Tables%20%26gt%3B%20Excel%20online%20-%20List%20the%20Rows%20Present%20in%20the%20Table%20%26gt%3B%20SharePoint%20%E2%80%93%20Create%20Idem.%3CBR%20%2F%3EI%20created%20a%20list%20on%20SharePoint%20and%20added%20a%20Calendar%20View.%3C%2FP%3E%3CP%3EWhat%20I%20need%20now%20is%20to%20add%20something%20to%20the%20flow%20to%20delete%20items%20in%20the%20list%20before%20I%20create%20the%20updated%20items.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 calendar. We have set up a report that runs every 15 minutes exporting data to an excel file. The data is not in a table format and is overwritten every time the report runs. The output file looks like the following.
BillToName, OrderType, SalesOrderNo, ShipExpireDate
John Dow, S, 3000859, 5/13/2020
Sports Construction, S, 3000900, 5/11/2020
Jan Smith, S, 300094, 5/13/2020
Bob World, S, 3001194, 5/13/2020
Sports Construction, S, 3001900, 5/11/2020
Sports Construction, S, 3001901, 5/11/2020
Sports Construction, S, 3001902, 5/12/2020
Sports Construction, S, 3001903, 5/12/2020
Sports Construction, S, 3001904, 5/13/2020
Sports Construction, S, 3001905, 5/13/2020
Sports Construction, S, 3001906, 5/15/2020

I have tried using Flow/PowerAutomate But I get lost when writing the data to a SharePoint list. I can export to CVS file using a batch file but I don't know what to do with it then. I am thinking if I know what kind of file a SharePoint list is, I could over-right it when a new file is created by ERP software. Otherwise, I would need to delete all events and write the new data. also need to save the SalesOrderNo column to the Title column. BillToName column to the Location column. ShipExpireDate column to Start Time column.

Any ideas on how to get this done would be appreciated.

 

2 Replies
Highlighted
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").
Highlighted

@derhallim

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.