Update SharePoint list with Excel Items

%3CLINGO-SUB%20id%3D%22lingo-sub-2150180%22%20slang%3D%22en-US%22%3EUpdate%20SharePoint%20list%20with%20Excel%20Items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150180%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20working%20on%20this%20for%20some%20time%2C%20it%20seems%20like%20it%20should%20be%20easy%20but%20has%20proven%20to%20stump%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20I%20use%20to%20track%20workplace%20safety%20incidents.%26nbsp%3B%20I%20have%20an%20excel%20sheet%20(set%20up%20as%20a%20table)%20that%20is%20downloaded%20from%20WCB's%20website.%26nbsp%3B%20I%20want%20to%20take%20certain%20cells%20from%20the%20excel%20sheet%20(4%20columns)%20and%20update%20that%20information%20on%20the%20SharePoint%20list%20using%20a%20commonality%20between%20the%20two.%26nbsp%3B%20In%20this%20case%2C%20the%20commonality%20would%20be%20the%20WCB%20claim%20number.%26nbsp%3B%20I%20would%20like%20the%20flow%20to%20be%20manually%20triggered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20offer%20some%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2150180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2151131%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20SharePoint%20list%20with%20Excel%20Items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F972635%22%20target%3D%22_blank%22%3E%40jleblanc95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20possible%20using%20Power%20automate%20flow.%20You%20need%20to%20upload%20excel%20file%20to%20SharePoint%2FOneDrive%2C%20then%20you%20can%20read%20the%20excel%20rows%20using%20Power%20automate%20and%20then%20update%20SharePoint%20list%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20references%20should%20help%20you%20to%20get%20started%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CA%20title%3D%22Add%20%26amp%3B%20Update%20Excel%20Data%20to%20SharePoint%20List%20using%20Power%20Automate%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DeDOwoPG9ua8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAdd%20%26amp%3B%20Update%20Excel%20Data%20to%20SharePoint%20List%20using%20Power%20Automate%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%3CLI%3E%3CA%20title%3D%22Update%20SharePoint%20List%20From%20Excel%20File%22%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FUpdate-Sharepoint-List-From-Excel-File%2Ftd-p%2F111477%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUpdate%20SharePoint%20List%20From%20Excel%20File%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%3CLI%3E%3CA%20title%3D%22EXCEL%20To%20SharePoint%20List%20Through%20MS%20Flow%22%20href%3D%22https%3A%2F%2Fwww.c-sharpcorner.com%2Farticle%2Fexcel-to-sharepoint-list-through-ms-flow%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEXCEL%20To%20SharePoint%20List%20Through%20MS%20Flow%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I've been working on this for some time, it seems like it should be easy but has proven to stump me.

 

I have a SharePoint list I use to track workplace safety incidents.  I have an excel sheet (set up as a table) that is downloaded from WCB's website.  I want to take certain cells from the excel sheet (4 columns) and update that information on the SharePoint list using a commonality between the two.  In this case, the commonality would be the WCB claim number.  I would like the flow to be manually triggered.

 

Can anyone offer some help?

1 Reply

@jleblanc95 

 

This is possible using Power automate flow. You need to upload excel file to SharePoint/OneDrive, then you can read the excel rows using Power automate and then update SharePoint list items.

 

Below references should help you to get started:

  1. Add & Update Excel Data to SharePoint List using Power Automate 
  2. Update SharePoint List From Excel File 
  3. EXCEL To SharePoint List Through MS Flow 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.