Import excel data into SharePoint using Power Automate

%3CLINGO-SUB%20id%3D%22lingo-sub-2470572%22%20slang%3D%22en-US%22%3EImport%20excel%20data%20into%20SharePoint%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2470572%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20sheets%20of%20excel%20data%20that%20exceed%2020%2C000%20rows%20and%20are%20not%20automatically%20in%20table%20format.%20Is%20there%20a%20Power%20Automate%20Flow%20I%20can%20create%20that%20will%20break%20up%20the%20data%20into%20different%20sheets%20if%20rows%20exceed%2019%2C000%2C%20convert%20into%20table%20formatting%2C%20and%20then%20upload%20as%20a%20list%20to%20a%20set%20SharePoint%20location%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2470572%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have sheets of excel data that exceed 20,000 rows and are not automatically in table format. Is there a Power Automate Flow I can create that will break up the data into different sheets if rows exceed 19,000, convert into table formatting, and then upload as a list to a set SharePoint location? 

0 Replies