cancel
Showing results for 
Search instead for 
Did you mean: 
0 Kudos

Parse Cell Data from Excel which is not in a Table

Parse Cell Data from Excel which is not in a Table for entry into SQL Table, SharePoint Lists, and writing to plain text files.

 

I would like to be able to have flow process a One Drive folder full of standardized data sets and compile the results into tables. 

 

Something along the lines of a Catalog Order form with a Cells to define Customer, Purchase Order and List of SKUs, and Qtys and for each  SKU where Qty > 0  add an entry to a sharepoint list of Customer, PO, SKU, Qty

 

Eventually we would like to output from the Sharepoint list to use this information to create an EDI document to import directly into our ERP.

Status: New